Hi everyone whos knowledge of excel I wish I had,

I hesitated to post as I have so far sound some similar posts that I am about to make, and macros that could come close but I just don't have the knowledge to de-bug and tweak for my own purposes.

The challenge, I need to convert the first column of data in a large amount of workbooks with multiple sheets(tabs) into one workbook with multiple tabs. It immediately gets complicated when the column range varies for each set of workbooks. It will always begin at A7 for every sheet in every workbook, but some columns are shorter than others. Now each workbook with multiple tabs needs to have the data in column A copied and transposed (turn it from column into a row) to another "merged sheet" inside of the "merged workbook" which will contain one tab per set of workbooks. And each row in the tabs of the final workbook ("merged workbook") will have the data from each set of input workbooks. So workbook set1 = tab1 inside the merged workbook. This may likely mean that a seperate macro or formula or process is needed for each set, which is totally fine because it cuts so much manual tedium.

I hope I'm clear so far and I hope this is possible, when I say workbook sets, it's just 4 or 5 workbooks (with multiple tabs) copied many times, but the data contained within them all is unique. In the merged workbook the first row will be pre-poulated with headings ready for the data to be slotted into row2 and below. Now if I may confuse you more, the data from each tab from the input workbooks needs to be continuous when it is displayed in the merged workbook. i.e. one long continuous row of data where cells A2 to H2 would all be from tab1 of an input sheet, I2 to M2 would be the data from the next tab. And so on and so forth. One row for one inputsheet, one tab for one set of inputsheets.

If you've read this far thank you very much and I am a confused fellow so I'll welcome any questions to clarify what I'm after If I've confused some of you helpful sorts. Much longer post than I anticipated. THE END