I have a worksheet that lists other worksheet names in column A. In column B,
I want to retrieve a value from the sheet listed in column A.

For example, if the value in A1 is "MySheet" (without the quotes), then B1
should return the value of 'MySheet'!M20. I tried building the formula:
="='"&CELL("contents",A1)&"'!M20"

But the cell just shows the formula I built as text, instead of the actual
formula.

Thanks for any help,
~ Horatio