Using a value in a cell as row reference

[RFGOfficeTC]

I am mirroring Cells from my datasheet to a second sheet. Is there a way to use the Value in A1 in the formula.

=Datasheet!A543. Is there a way to make "543" come from a reference cell. 

I would like to be able to type the Row number I want to mirror in Cell A1 and have it update the row number in the Formula.

=Datasheet!A (and then #in Cell A1)

Thank you

[#2 · Accepted solution]

@RFGOfficeTC So the reference cell with the row number is A1. Then use this formula:

=INDIRECT("Datasheet!A"&A1)

[#3]

This worked Perfectly. Thank you.