I have a workbook with multiple worksheets.
Sheet 1: Has information needed to be retrieved and put into specific cells on
Sheet2.
Sheet 2: Col. A lists names of worksheets in workbook
In Col. B I want to write a formula that will lookup the
worksheet, using
the worksheet name in Col. A, then retrieve a value in a
specific cell on
that worksheet.

I don't want to "hardcode" the name of the worksheet in the formula (i.e.
'Sheet1'!H14), because that sheetname will always be changing.