I have a large number of cells on sheet1 (approx 1,300)
which need 3D sums from other sheets in the same book. I
have decided to try and do this using code but have been
unable to get it to work.
Another complication is that a new sheet is added to the
file every week.
What would be the code for the following and how could it
be amended to take into account of the new sheet each week?

=SUM('WE 8 4 05:WE 1 4 05'!R4)

Thanks in advance.

Gareth