Perhaps something like
=INDIRECT(ADDRESS(5,3,,,"Week"&(ROW(A6)-5)))
entered into cell in row 6, and copied down.


"Lilly" wrote in message
...
I need to copy a formula down a row, referring til 52 sheets (one for each
week).
f.ex.: =week1!$C$5
=week2!$C$5
=week3!$C$5
up to week 52

Any good ideas how to do this ?