You seem to have things neatly arranged & under control as far as I can see
?
(your layout is not suitable for pivot, but this is not relevant here)

Eg your typical point cell formula in Weekly Summary's B3:
=SUM('Week 1'!B3,'Week 1'!F3,'Week 1'!J3,'Week 1'!N3,'Week 1'!R3)
is easily propagatable across/down for the week

Similarly with the next one in F3:
=SUM('Week 2'!B3,'Week 2'!F3,'Week 2'!J3,'Week 2'!N3,'Week 2'!R3)

And the same thing goes for the formulas in Monthly Summary

Maybe just a small point on using Edit Replace for replicating formulas in
this kind of scenario:
To "replicate" B3's formula for F3. You could say, remove the equal sign
temporarily in B3's formula, then copy the formula n paste into F3. Then
just use EditReplace to replace (in F3): Week 1 with: Week 2, then
re-instate both equal signs in B3 & F3.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RMP" wrote in message
...
Thanks Max,
I have uploaded the file, please access on the link below.

http://www.freefilehosting.net/download/3a323

Look forward to hearing back from you.
--
RMP