Sum the same cell across multiple sheets - variable number of sheets

[ROBJ]

Hello

Please see attached. I might have answered my own question by adding a "helper" WS before the 1st & last week of the month for formulas to update. " =SUM('JAN START:JAN END'!C5) "
Not the most elegant solution, but it works.
I am still in dire need of help with some of the VBA code for this WB. Do I need to start a new thread or just post the code on this one?
Again, very much appreciate your help.

Thanks

Rob