One way:

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

In article ,
"AndrewB" wrote:

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!