I'm going to do this with a helper column so that you see what's happening.

A2 = 1
A3 = A2+1
A4 = A3 + 1

etc.
B2: =INDIRECT("Sheet"&A2&"!A6")
Copy down


"blinkgirl119" wrote:

Hi

I am looking to use the formula =Sheet1!A6 in a column, with the formula
changing each cell you go down, to =Sheet2!A6, =sheet3!A6 etc.... so it is
the sheet that changes, not the cell the data is getting taken from....how do
i do this? I think it is with the $ symbol, but i cant get it to work! Any
help will be appreciated!

Thanks in advance

Fiona