Just close the source wookbook and do it again with the next one, until you've collected all the worksheets you care about into one large wookbook. Would you like to answer one of these unanswered questions instead?
Consolidating data is a useful way to combine data from different sources into one report.
Each range of data should be arranged in cross-tab format, with matching row and column names for items that you want to summarize together.Usually i did this by doing copy paste all values one at a time into a new empty spreadsheet, or copy to merge sheets to another excel files one by one.But yesterday my friend show me a simple way to combine or merge multiple excel files with macros inside Excel 2007 (edit macros with MS Visual Basic editor and no download required). Close Next End Sub If you set a new folder within the code, and then hit “F5” or press Sub Run button, the result will be added into current worksheet bellow the previous data.Do not include any total rows or total columns from the source data when you specify the data for the report.If you get workbooks that have identically structured data on each worksheet, you may be interested in a way to combine the multiple worksheets into a single, large worksheet.