I want to link to a cell on another worksheet in the same workbook. Instead
of the value of the first cell showing in the second cell, the formula from
the first cell appears in the second cell. What am I missing?

Thank you.