Using Links to Automatically Update or Consolidate Worksheet Data

Use links to share data between cells or ranges in one worksheet and another location in the same workbook or a different workbook. Just as a formula displays the results of a calculation, a link looks up data from another location and displays it in the active cell.

Links offer a powerful technique for consolidating data from different sources into one worksheet without requiring that you re-enter or copy data. For example, a teacher might use separate worksheets in a single workbook to keep track of test results for each class, with a separate worksheet that organizes results into an alphabetical list by student.