Looking up values on another worksheet

[Steve F]

if i have a summary workheet where there are two columns

Column A Column B
sheet2 =Sheet2!$I$26
sheet3 =Sheet3!$I$26
sheet4 =Sheet4!$I$26

is there away to amend the "worksheet" name in column B so that it
uses the value in column A

ie. what function in column B for 1st set of data can return the value
of cell I26 from the worksheet refrred to in Column A?

Hope this makes sense

Thanks in advance

Regards
Steve

 

[Dave Peterson]

=indirect("'" & a1 & "'!i26")

if i have a summary workheet where there are two columns

Column A Column B
sheet2 =Sheet2!$I$26
sheet3 =Sheet3!$I$26
sheet4 =Sheet4!$I$26

is there away to amend the "worksheet" name in column B so that it
uses the value in column A

ie. what function in column B for 1st set of data can return the value
of cell I26 from the worksheet refrred to in Column A?

Hope this makes sense

Thanks in advance

Regards
Steve