linking multiple worksheets

[wooltrees]

I know this is possible because we have a document at work that does
this -- just can't figure out how:

I have multilple worksheets in a workbook and I want to merge the data
on to one worksheet so that the numbers add up and so that the summary
page is linked to each worksheet -- changes are made in individual
worksheets. I can see the cell formula, but know there is a quicker
way to do this than typing in formulas for each cell.

All of the worksheets are identical.

Thanks.

 

[David Hager]

Use Data, Consolidate.