Repeating pattern on my second sheet

I

iomighty

I have used VBA successfully to copy items from my worksheet to m
second worksheet in my desired format.

Is there a way to instruct the columns in in worksheet to repeat th
pattern I created for the second sheet
 
Top