Help creating Summary Page w/ user defined sheet names

I'll do my best to explain. Need help creating a summary page using a macro crafted by JBeaucaire that creates worksheets in a workbook generated by a column of location names that are entered by various managers. The number of locations and their respective names are unknown. However, the worksheets created are essentially copies of a template called "Master" and the worksheet with the location names is called "Locations". I'm looking to add up the same totals for all of worksheets, except "Locations" and "Master" which appear in column "BD" starting with cell BD8 on all of the copied sheets and have the totals appear in column "C" starting with cell C8 on the "Summary Page". I did some minor tweaking to the code that JBeaucaire provided below:

Please Login or Register  to view this content.

Any help is appreciate. I wasn't sure if I could use for example: Sum('Sheet4:Sheet41'BD8) seeing that I wouldn't know how many sheets would be created; the maximum number of sheets is 41.

The code that I was trying to use to create the Summary Page is, but it only totals the last entry on the locations worksheet ignoring all others:

Please Login or Register  to view this content.

Do you have a sample file that you can upload?