Do you by chance mean you wish to Sum cell A1 form sheet2 through sheet100
and place it in cell A1 of sheet1?
If so in cell A1 of sheet1 enter:
=SUM(Sheet2:Sheet100!A1)

HTH

"glenlee" wrote in message
...
How do you return all sheets of a workbook to cell A1 all together?