add the same cell on several worksheets to another worksheet

[tea1952]

what i want to do is be able to add a cell like D3 on 53 different worksheets
and place the sum on another workssheet in the same workbook. easiest way to
explain is i need a weekly report and want to toal the same cell to a year
end report in the same workbook.

 

[Peo Sjoblom]

In the Summary sheet, type equal sign and sum plus one parenthesis

=SUM(

select the first sheet tab, hold down shift and select the last sheet tab,
click D3 and press enter you will get

=SUM(Sheet1:Sheet53!D3)

of course your sheet names are probably week numbers or something

Regards,

Peo Sjoblom