VLOOKUP with variable sheet name

[raikks]

Book1
	A	B
1	Mike	54
2
3	Sheet2
Sheet1

Cell Formulas
Range	Formula
B1	B1	=VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0)

Book1
	A	B
1	Alex	91
2	Adriana	40
3	John	84
4	Diana	25
5	Mike	54
Sheet2

Book1
	A	B
1	James	79
2	Robert	76
3	Patricia	94
4	Mary	18
5	Thomas	91
Sheet3

I have and Excel file with 3 spreadsheets.
In Sheet1, in VLOOKUP formula (cell B1), instead of modifying the name of the sheet into the formula, is it possible to link cell A3 with cell B1?
So instead of { =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0) } to have something like { =VLOOKUP(A1,A3!$A$1:$B$5,2,0) } ?
I would basically like to input data only in cells A1 and A3 and cell B1 to update automatically.
I'm not sure if I made myself clear...

 

[maabadi]

Try this:

=VLOOKUP(A1,INDIRECT("'"&$A$3&"'!"&"$A$1:$B$5"),2,0)

 

[raikks]

I can't stop smiling - it works perfect.
Thank you!

 

[maabadi]

You're Welcome & Thanks for follow-up.