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

    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!