A workbook link (previously called an external reference) is a way to combine data from other workbooks or other sheets in the same workbook. You might want to use them to: Link workbooks from several departments and then integrate pertinent data into a summary workbook. When the source workbooks change, the summary workbook is updated. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.