Hi

You can use something like this:
=SUM(Sheet1:Sheet3!B15)
to sum cell B15 on all sheets between the one labelled Sheet1 and the one
labelled Sheet3.
Hope I understood your question correctly!

--
Andy.


"hm" wrote in message
...
I want to summarise all the information from a 3d reference (data collected
from the same cell on many worksheets) onto the one sheet.