hi
try this...
=SUM(Sheet1:Sheet52!N35)

regards
FSt1

"Michael Higgins" wrote:

Hi i have a sheet set up for each week for my work and i am trying to do
auto sums to add each weeks figures from Cell n35 at the end i will have 52
sheets so i would like to know how to add figures from each week
automatically.

Many thanks

Michael