I have two sheets in my workbook. Sheet1 is able to see all cell references
in both Sheet1 and Sheet2. The Sheet2 is only able to see references to cells
contained on Sheet2.

How can I make the cell references visible to both sheets?

Thanks