Hello!

I have a workbook with five sheets (left to right) named
with text names, then a sheet named AREA, followed by
various sheets whose tabs(names) are numbers. The AREA
sheet is a summary sheet and consists of many formulas
such as SUM('16:56'!E6), referring to the sum of E6 in
Sheets 16, 23, 25, 20 and 56.

I need to copy this workbook about 50 times and plug in
numbered sheet tabs that are different than the original
workbook (all text-named sheets remain the same).

The thought just occurred to me that I am going to have to
physically change each formula to correspond to the new
workbook's new sheet numbers! Yikes!

Is there a more generic way I can write a formula so
that it will, for instance, sum the cells in all the
sheets after "AREA" or some kind of code that can be used
in conjunction with the formula that only takes a cell
value from the numbered worksheets ... or something?

Any help will be greatly appreciated!

Sandy