formula help

[myecrip]

i have a workbook with 52 worksheets (1 for each week of the year). i want to make a balance sheet that will add up the exact same cell from each wprksheet, but i dont want to have to type the entire string in. is there a way to group the worksheets together or make it easier

thanks
dave

 

[Brian from Maui]

i have a workbook with 52 worksheets (1 for each week of the year). i want to make a balance sheet that will add up the exact same cell from each wprksheet, but i dont want to have to type the entire string in. is there a way to group the worksheets together or make it easier

thanks
dave

Insert two new worksheets named First and Last and place all 52 sheets between the two. In the summary sheet enter,

=SUM(FIRST:LAST!A1)

where A1 is the cell to sum on all 52 worksheets.