How to Link Data on a Worksheet to Another Worksheet in the Same Spreadsheet. Linked cells often make it easier to organize spreadsheet data that's spread among several worksheets.

When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet.

In the ribbon, click View > Arrange All > Vertical > OK. The two workbooks will now appear in the same window, as shown below. See this short tutorial video for Windows users or this tutorial video ...