Using A Cell To Reference The Name Of Sheet In A Formula For Google Sheets

Yes, by using the INDIRECT function:

A1: Sales Report - WB 10.06

Then you can use:

=INDIRECT("'"&A1&"'!B3")