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

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!

Where is the example of how you want it to look after the macro is run?

I have updated my workbook to include the data I am looking for on Sheet 2. Technically, the range doesn't need to go A1:F41, but instead, can end when empty. Whatever is easiest.

Sorry to be a pain, but I need to figure out how to find, via code, the actual data, so I would like to see how the data would be set up if there was more data. Specifically if there was more data below what you have. Is it always going to be formatted the same way with the header row Item # etc and some data below that and then another header row for a new section of data below that and the header rows would all be on the same row across?
I modified your sheet to show what I am asking. I just copied the same data, but I think you see what I mean.

That's good, but here's what I'm the most interested in.

If you look at the sheet I posted in post #5

You see how I pasted some more data, highlighted in yellow below your original data.

I have some questions. Would there ever be another section of data below what you included in your example?

If so, you see how I have in row number 25 the header row for the new set of data A25 and the second set of data G25 and both are on row 25, would this be the case if you have sets of data below the original.

Here's the technical reason I ask. If they would be on the same row then I would just have the code look for Item# in column A and I would have my new row to start looking for data to copy, otherwise for each section of data I would have to search for the item# gain.

So if in the second section of data instead of item number being on the same row, row #25 it was staggered and might be on row #27, then I need to know this.

Okay the last thing I should have asked and didn't, is row 9 always empty like you show in your sample?

I went ahead and assumed it was. If it's not let me know it's an easy fix.

Alt + F8 to bring up the macro list, then run the macro.

That's perfect! You made it look so simple. Thank you very much!

One last question, if you don't mind. If I also needed the BOM Description (rows 3-7) to repeat itself for each section, within a new column, could this be added to the macro? I've attached a new file to better describe what I need to happen (highlighted on Sheet 2).

Try this.

When you get to column RM there's now seven columns until the next item# label. RM, RN, RO, RP, RQ, RR, RS, then the next item# label is RT. You have 2 SEQ# labels. So after that the columns the code is looking for the data in are all off.
I would check for other extra columns.