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.

To learn more about implicit and explicit references, read Excel tips: How to select cells and ranges efficiently using VBA. There are many modifications you might want to make.