For instance, if a cell in one worksheet has a sales number, you can display that value in another worksheet by adding a reference to that cell.

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.