Macro for summing identical tables from different sheets in same file

[mrcruse]

Hello all,

I have an Excel database that has 52 weekly tabs named "Week 1", "Week 2", etc. The tables are identical and they are currently being summed into 2 26-week tabs for 6 month reports. These two tabs are fixed and locked for protection.

Is there a macro to set up a dynamic reporting page that can pull in weekly tabs based on the Start and End weeks?

Thanks in advance!