Combine multiple sheets from multiple workbooks

  • Hi,


    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
    etc.


    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!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!