Variable Sheet Name in Function

[keriblueberry]

How do I express ='sheetname'!A1 when the sheet name is variable?

[#2]

@keriblueberry You can consider to use Indirect function. Useful explanation on how to use it could be found here https://www.contextures.com/xlFunctions05.html