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,