Hello!
Here is the example of the INDIRECT function that returns the value of the specific cell in the specific sheet.
=INDIRECT("'"&"SheetName"&"'!B2")
(1) What is the role and the meaning of the first single quote surrounded by double quotes?
(2) What is the role and the meaning of the second single quote and the following exclamation mark?
Thank you very much!
Bookmarks