aside from the doing this manually each time i either create a list or new sheets is there a formula for what i am trying to accomplish?
i have a workbook with lets say 4 worksheets.
work sheet 1 has my list of the other sheets names so we'll call it index.
Index
sheet-A
sheet-B
sheet-C
on my index works sheet i have a formula generating the additional sheet names (because i add more as time goes on, so this may be my problem is that they are not just written in name, but i am trying to remove as much manual input as possible.)
so in column A its
sheet-A
sheet-b
sheet-c
i need column B to provide the value in cell A1 on any given sheet.it will always be the same cell on each sheet.
so the results would be
Column A Column B
sheet-A 11
sheet-b 22
sheet-c 33
i have a workbook with lets say 4 worksheets.
work sheet 1 has my list of the other sheets names so we'll call it index.
Index
sheet-A
sheet-B
sheet-C
on my index works sheet i have a formula generating the additional sheet names (because i add more as time goes on, so this may be my problem is that they are not just written in name, but i am trying to remove as much manual input as possible.)
so in column A its
sheet-A
sheet-b
sheet-c
i need column B to provide the value in cell A1 on any given sheet.it will always be the same cell on each sheet.
so the results would be
Column A Column B
sheet-A 11
sheet-b 22
sheet-c 33
