Link Data from Multiple Worksheets

[Danedel]

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?

[Max]

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

where:
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" <Danedel@discussions.microsoft.com> wrote in message
news:B1701373-628E-4B88-88CE-788AB3ECC80E@microsoft.com...
> 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?