Forum Discussion
Solved
Incrementally creating different sheet names within a workbook on a single sheet
I have a cell in my main workbook sheet that references and pulls information in from a cell on a different sheet within the workbook. Let's say my additional sheet is called simply "2" (or it could...
Create a list of the sheet names in a range of cells, e.g. in A2, A3, A4 etc.
If the sheets are really named Sheet2, Sheet3 etc. you can do this by entering Sheet2 in A2 and then filling down.
In B2, enter the formula
=INDIRECT("'"&A2&"'!D7")Fill down.
Create a list of the sheet names in a range of cells, e.g. in A2, A3, A4 etc.
If the sheets are really named Sheet2, Sheet3 etc. you can do this by entering Sheet2 in A2 and then filling down.
In B2, enter the formula
=INDIRECT("'"&A2&"'!D7")Fill down.
HansVogelaar That seems to be working. Thank you!
