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.