Assuming your weekly worksheets are contiguous and named Weekn (n=1 to 52),
enter the following in Total Worksheet:
=SUM(Week1:Week52!A1)


HTH
--
AP

"obviscator" a écrit dans le message
de ...
how do i get a running total from the same cell on multiple worksheets
that
updats as I add more worksheets to the file

ie. i am keeping a weeks work on a new worksheet in the same file and want
a
worksheet that runs totals for all the weekly worksheets and i want the
totals worksheet to update as I add more weekly worksheets.