There is.

Insert a new blank sheet at beginning. Name it "First"

Insert a new blank sheet left of your summary sheet. Name it "Last"

In summary sheet enter =SUM(First:Last!E12)

When you need more sheets make sure you insert them between First and Last.


Gord Dibben MS Excel MVP

On Tue, 3 Jul 2007 03:54:01 -0700, msiz wrote:

yeh was hoping for an easier route!!

"Barnej75" wrote:

=Sheet1!E12+Sheet2!E12+Sheet3!E12

This is the easiest way I know.

HTH

Jason