Summarizing several workbooks

[lukecardoni]

I have worked in excel for a number of years but have always done things the hard/long way I guess you could say. Looking for a little help with a fairly large task to save a bit of time and sanity.

I have 4 years of data that I need to total and summarize. Within those 4 years I have 25 individual and identical workbooks that correspond to a satellite within my company's scope of work. Each of the 25 workbooks have 4 identical sheets that correspond to our measurable efforts. I am looking to create a "Summary" workbook that will essentially pull in the data from the sheets of the work books into a total sheet in the summary workbook.

Essentially, Sheet 1 of Workbooks 1-25 ---> Sheet 1 of Summary Workbook, Sheet 2 of Workbooks 1-25 ---> Sheet 2 of Summary Workbook, etc.

I have done merging of sheets into a workbook (rightclick, merge/copy, etc.) but only with single sheets, never with this many.

Help, thoughts, and solutions would be greatly appreciated If there is any more information I can provide or examples please let me know!

 

[Jubjab]

This is relatively simple to accomplish with VBA

1. Get some code to open all files, either by specifying all file names and paths and looping through this list, or having all files in a folder all have VBA open all files in the folder.
2. Copy and paste the data to your Summary file
3. Close the processed file

You can find ready code by googling, or if you give more detailed info it's also possible to give some ready code to do this.

 

[McDawg81]

see addin here:RDBMerge, Excel Merge Add-in for Excel for Windows