Hi,

No I did mean E73 to I91 as they are rooms in a student accomodation block.

cheers

"Gord Dibben" wrote:

Did you mean sheets E73 to E91?

Why are you referencing sheet E64 and E65 and E66?

Maybe this may be easiest method if you do have typos in your original post.

=INDIRECT("E"&(ROW(64:64)&"!K23"))

Drag/copy down.


Gord Dibben MS Excel MVP

On Fri, 12 Sep 2008 03:07:07 -0700, Blade370
wrote:

I have a workbook with multiple spreadsheets from E73 to I91. On each sheet I
have a total that I would like to copy to a summary sheet. I have pasted the
first formula into the summary sheet which is ='E64'!$K23$. I now want to
copy this formula down with the sheet reference incrementing by one e.g the
next one needs to be ='E65'!$K23$ and the next ='E66'!$K23$ and so on.

What is the best and easiest way to do this???

Many thanks in advance