Insert variable in to formula (cell lookup)

what i'd like to do is have a formula that can look at a value and insert it into a formula

eg.
='4 - Modelling Raw Data'!AE$1
='4 - Modelling Raw Data'!AN$1
='4 - Modelling Raw Data'!AW$1
='4 - Modelling Raw Data'!BF$1

for the next worksheet / tab i have the same formulas but this time they need to look at the next row down

='4 - Modelling Raw Data'!AE$2
='4 - Modelling Raw Data'!AN$2
....

is there an easy way to edit the formula so that i could define a value once which would get encorporated into the formula

so ='4 - Modelling Raw Data'!AE$####

where ### is 1 on sheet 1, 2 on sheet 2...

i have 50 tabs with about 100 formulas on each page its going to take me ages if i have to do this manually.

EDIT: A find a replace $1 with $2 seems to work would still need to be careful not to accidently ruin any other formulas by mistake. would still be useful if someone has any ideas on the above

If as implied the pattern to your results is 9 columns per row then if we assume you store the row of interest in say A1 with first formula in A2 (to be copied down):

A2:
=INDEX('4 - Modelling Raw Data'!$AE:$XFD,$A$1,1+9*(ROWS(A$2:A2)-1))
copied down as far as required

copied to other sheets - modifying A1 as appropriate.

The pattern allows you to use a single formula for all.