Using A Cell To Reference The Name Of Sheet In A Formula For Google Sheets June 28, 2023 by Tarik Yes, by using the INDIRECT function: A1: Sales Report - WB 10.06 Then you can use: =INDIRECT("'"&A1&"'!B3")