Welcome to the forum.

One choice would be:

=INDIRECT("'Sheet "&$A$1&"'!B2")