No such feature in Excel versions <2007....can't speak for 2007.

Try this method...............

Add a new blank sheet to the right of your Summary sheet

Add a new blank sheet at end.

Name these Start and End.

On your Summary sheet in a cell enter =SUM(Start:End!B5)

This will sum all B5's on sheets between your two dummy sheets

In future when adding/deleting sheets do so between Start and End.


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 16:16:00 -0800, Davidt
wrote:

I have a workbook containing several worksheets and a summary sheet that
refers to all the other sheets with a 3D reference. I need to fix the 3D
reference just as I can fix a cell address by entering $A$5 (eg).

So my reference would appear as =SUM($Sheet1:$Sheet10:B5) - this would allow
me to delete, rename the boundary sheets without the reference being affected
in the summary sheet.

Is there any way to do this or otherwise protect the reference in summary
sheet?

Thanks