Cell reference for tab name
 

I have a summary sheet column of tab names for over 100 spreadsheets.
In the next column I need to reference a certain cell E2 in all of the
spreadsheets.
For example, for worksheet with tab name CAB I use =CAB!E2
Instead of manully editing each cell is there a way to reference the text in
the first column, e.g. CAB, to refer to the worksheet by that name in the
=CAB!E2 cell.
That way I only have to type in each worksheet name once in the first
column, and can save time editing numerous rows by dragging the series down
from the top row.
Thanks,

Cell reference for tab name
 

Thanks - this works perfectly

"Luke M" wrote:

Assuming Sheet names start at A2
=INDIRECT("'"&A2&"'!E2")
Copy down as desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kris" wrote:

I have a summary sheet column of tab names for over 100 spreadsheets.
In the next column I need to reference a certain cell E2 in all of the
spreadsheets.
For example, for worksheet with tab name CAB I use =CAB!E2
Instead of manully editing each cell is there a way to reference the text in
the first column, e.g. CAB, to refer to the worksheet by that name in the
=CAB!E2 cell.
That way I only have to type in each worksheet name once in the first
column, and can save time editing numerous rows by dragging the series down
from the top row.
Thanks,