IsaacMessi10 0 Junior Poster in Training

Sheet1
A1: Football
A2: Rugby
A3: Basketball

Sheet2:
A1: A2
A2: B4

How can I get a location of a field from String? Is it even possible?
eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'