Explanation
The INDIRECT function tries to evaluate text as a worksheet reference.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
Dynamic worksheet reference
To create a formula with a dynamic sheet name you can use the INDIRECT function. In the example shown, the formula in C6 is: =INDIRECT(B6&"!A1") Note: The point of INDIRECT here is to build a formula where the sheet name is a dynamic variable. For example, you could change a sheet name (perhaps with a drop-down menu) and pull in information from different worksheet.
