Hi srpettew,

Assuming you summary sheet has formulae linking to the others, the data
should update automatically anytime the worksheet re-calculates.

Cheers


"srpettew" wrote in message
...
Hi,

I have several tabs (worksheets) representing purchases for a specific
year.
There is one tab (worksheet) that is a Summary of all purchases for all
years. How do I get Excel to automatically update the Summary worksheet
anytime one of the other worksheets are modified?