I have a number of workbooks each consisting of 5 sheets.
I am trying to create a master workbook that will append all of the data from each sheet with that of its counterparts from the other workbooks.
So Sheet 1 = All data from all sheet 1's
Sheet 2 = all data from all sheet 2's
The data format, sheet names and headers amongst all of the same # sheets are identical, only the values change. Also, it is not a set number of rows for any given sheet.
Another possible complicating factor is that the files I get are in xml format, though I can re-save them as something else if need be.
Thanks in advance!