Using a variable to house a row reference?

[jmracura]

I've been struggling to find and answer to this one and could use some help if it's out there. I have recap sheet with about 50 formula cells, pointing to other sheets, different columns, but all the SAME row. I'm manually updating these 1 by 1 and since the only thing that changes is the row, is there a way to assign it a variable and update them all at once? There has got to be a more efficient way for me to do this that won't lead me to mistakes as it does today.

Many thanks in advance.

day 1
=sheet1!a1
=sheet2!a1
=sheet3!a1


day 2
=sheet1!a2
=sheet2!a2
=sheet3!a2

I apologize if this is on here somewhere else already but I guess I'm not calling for it correctly in my searches.

 

[jmracura]

Just to be clearer, the column names are all over the place in my workbook.

day 1
=sheet1!a1
=sheet2!s1
=sheet3!w1


day 2
=sheet1!a2
=sheet2!s2
=sheet3!w2

 

[RoryA]

Let's say your day (row) number is in Z1:

=INDEX(sheet1!a:a,Z1)
=INDEX(sheet2!s:s,Z1)
=INDEX(sheet3!w:w,Z1)

will do it.

 

[jmracura]

This completely worked! I appreciate the help so much Rory. More so now that my back up colleague is taking leave and this will give me back some time each day.

 

[RoryA]

Glad to help - Merry Christmas!