Phil,

Look at Data - Consolidate.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Phil Osman" wrote in message
...
I have over 70 sheets with the exact same layout which I want to
consolidate.

There is a list of all the sheet names on my summary page in Cells L6:L77.
I
tried using:
=SUM(INDIRECT("'"&L6:L77&"'!AV32"))
with AV32 being the first cell on each sheet I want to summarise.

But it only returns the amount from the first sheet.

Any ideas?

--
http://www.redbrick.dcu.ie/~pele