Forum Discussion
Pulling data to a summary sheet, from select cells in many different sheets
The INDIRECT function can do this IF you change your sheet naming convention to use underscore instead of hyphens. (i.e., MB_1_9_20 instead of MB-1-9-20) For mysterious reasons (to me at any rate) the hyphens caused #REF errors. As soon as I changed the sheet name, no problem.
I added a row across the top to give the cell references to the INDIRECT formula, which ends up, then, pulling the sheet from the name entered in column A, and the cell references from Row 1.
=INDIRECT($A3&"!"&B$1)
This is the formula in cell B3 of your summary sheet. It can be copied, because of the relative and absolute references, to each other cell where you want things summarized.
The INDIRECT function can do this IF you change your sheet naming convention to use underscore instead of hyphens. (i.e., MB_1_9_20 instead of MB-1-9-20) For mysterious reasons (to me at any rate) the hyphens caused #REF errors. As soon as I changed the sheet name, no problem.
I added a row across the top to give the cell references to the INDIRECT formula, which ends up, then, pulling the sheet from the name entered in column A, and the cell references from Row 1.
=INDIRECT($A3&"!"&B$1)
This is the formula in cell B3 of your summary sheet. It can be copied, because of the relative and absolute references, to each other cell where you want things summarized.
