Help! - Copy Range (Sheet1,A10:F50), Paste Range (Sheet 2,A1:F41), Offset Range & Repeat

[cjtimmer]

I have long been searching for the solution to my Excel problem and am about to throw in the towel. Can anyone please help me write a macro that works as described below:

I have a very large worksheet that has data entered horizontally with a 6 column by 40 row range and I would like to copy that data to a new worksheet and stack it vertically within 6 columns for importing purposes. How can a write a macro that will make this function simple? Every range will be the same size, but I need to move the data from 5,000+ columns on Sheet 1 to only 6 columns by 5,000+ rows on Sheet 2 instead. I have attached a sample spreadsheet to better show what I am trying to accomplish. Thanks in advance for your help!