Replacing a formula with another cell

I have a specific cell which uses the lookup function, however I have many sheets. Without using a macro, is there anyway to have another cell where someone enters the Sheet Name and it replaces 'Sheet1' in this lookup formula?

So one cell has this formula:
=VLOOKUP(D4, Sheet1!A4:B364, 2, TRUE)

And if someone replaces A1 from Sheet1 to Sheet2, I would like this formula to change accordingly.

Any help would be greatly appreciated. Thanks

Thank you so much

that worked !