Consolidating Data Across Workbooks with multiple sheets from same template

[alexu95]

I will have an unspecified amount of workbooks all stemming from the same template. I want to take data from all the workbooks in a certain folder (They're all identical but for the values in the cells) and sum up the data in specified cells on a new master sheet.

 

[Datsmart]

You did not give any details of what cells you want to copy.
This earlier code will cycle through WorkBooks in Folder and perform a copy of a range of data. It should help with your needs.
http://www.mrexcel.com/forum/showthread.php?p=1101793#1124766

 

[alexu95]

The cells contain numbers (this is for finance). So for each wb I have a master sheet with the sums for that work. I want another master wb for all the other wbs which will sum up the numbers in the specifed cells.

 

[alexu95]

Anyone got an idea?