Searching multiple tabs for the value of a single cell corresponding to the tab

[Cooperx5]

I have a workbook with several tabs. Within each tab there is a single cell (O1) that has a sum in it. I have used the INDEX function to create a "Table of Contents" tab with the names of all the tabs on it.

Question: What function do I use to "look" at the name of the tab created by the INDEX function and copy the value of 01 for that tab.

Sample:
Index formula [=INDEX(MID(Students,FIND("]",Students)+1,255),ROWS(A$1:A2)) ] creates this list in column A:

Instructions
Talley
Master
Student1
Student2

How do I look at column A (above) which is a formula and return the result of cell O2 for that particular tab?

 

[karenjoy511]

Try this formula in B2 where A2 has the name of the sheet with the cell you want to reference:

=INDIRECT("'" & A2 & "'!O1")

 

[Cooperx5]

PERFECT - Thank you.