A link can be as simple as a reference to a cell on another worksheet, or it can be part of a formula. You can link cells between sheets within one workbook or between different workbooks. Cell data to be linked is called the source data. The cell or range linked to the source data is called the destination cell or destination range. If you no longer want linked data to be updated, you can break a link easily. Create links instead of making multiple identical entries; it saves time and ensures your entries are correct.
Create a Link Between Worksheets or Workbooks
Break a Link