Something like this in say, Sheet4's B2:
=SUM(Sheet1:Sheet3!A1)
will return the sum of what's in A1 in Sheets 1, 2 & 3

whe
Sheets 1 & 3 are the "bookend" sheets
Sheet2 is assumed placed in-between Sheets 1 & 3
Sheet4 (the "summary" sheet) is assumed not within Sheets 1 & 3
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Danedel" wrote in message
...
Is there a way to link data from multiple worksheets in the same workbook
to
a single worksheet used as a "running total" also in the same workbook?