return cell from named sheet

[AndrewB]

Hi,
I have a list of sheet names in column A and want to return the value of the
repective sheets cell E10 in column B.

Many thanks in advance!

 

[JE McGimpsey]

One way:

B1: =INDIRECT("'" & A1 & "'!E10")