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 Cells From One Spreadsheet to Another. Linked cells in Excel spreadsheets update data in real time. This ensures values remain constant between pages and avoids errors due to outdated ...

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.