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