Try:

=INDIRECT("LA" & ROWS($1:1)+4 & "!$B$5")

and copy down. The sheet reference will increase, but the cell reference
will be the same.
--
Gary''s Student - gsnu200779


"JOJO193" wrote:

I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193