This example shows how the INDIRECT function pulls data from cell A1 of different sheets based on the sheet name listed in column B.
Excel formula using INDIRECT function to link to dynamic sheet names
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #347450