Macro Copy and Paste to create desired template

Dear Admin,

Please read all the explanation in the excel workbook, I tried my best to explain my situation inside the workbook. Kindly assist, Thanks a lot.

I wish I can create a macro can help me copy
and paste using Range Name as variable.

Please Login or Register  to view this content.

However, I dunno how to continue with
excel will smart enough to help me copy
and paste the second combination just right
below the 1st combination and so on.
I don’t want to use. Select due to I can't estimate
every combination might be consist of 2 or 3 or 4

Do you mean

Please Login or Register  to view this content.