My search for this has not gone well...

I have a list of worksheet names within the book I am working with.
I need to point to any one of the names on the list and use it to find the value of a cell within the selected worksheet.

Please assume the name of the worksheet is "Harry Smith" located in cell B27 on the active sheet and the information I need on the selected sheet is found in cell E12.

What does the formula look like?

Thanks in advance!