Macro to run through each value in drop down box and copy paste re
 

Is there a way to make a macro that will select each value in a drop-down box
and then copy and paste the results on another sheet in a continuous fashion
to create a look-up table for a formula in another spreadsheet?