Excel Macro to select the each values from drop down list and copy-paste the values

I have excel sheet which has lot of calculation based on the values available in drop-down list in B1.

So far what i have done is,
1. Created a drown down list in cell B1 in sheet "ACCM Configurator" based on the range from sheet "Analysis - Template" $A:$A (ignored blanks)
2. Based on the value selected the down list in cell B1, I have created many calculations using formula in places those in A6:J33 in sheet "ACCM Configurator"

What I want to achieve now is,
1. select each values in drop down list in B1 and copy the calculated values for each drop-down values from the range A6:J33 and paste in a new sheet called as "ACCM Append"
2. Ignore any blank rows
3. A5:J5 has headers, so expected this to be paste as a header in sheet "ACCM Append"

Any thought on this please...