See Excel Help on "linked cells"

You can link cells on separate worksheets to one master sheet.

The linked cells will update on the master as they change on the sheets.

e.g.

To sum up the same cell on each sheet into the master sheet enter this formula
on the master in a cell.

=Sum(Sheet1:Sheet4!H23)

This will sum up H23 on each of Sheet1 through Sheet4 to give a grand total.


Gord Dibben MS Excel MVP


On Tue, 25 Apr 2006 14:19:01 -0700, misselainei
wrote:

I have an excel book with numerous pages and total amounts on each one. I
want a seperate page with all these totals, grand totals, on and I want it to
be connected to the pages in the workbook so the amount changes on the grand
totals page. To make life easier I don't mind being e-mailed at,
. Thanks, Elaine.