Forum Discussion
Variable Sheet Name in Function
How do I express ='sheetname'!A1 when the sheet name is variable?
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