Whenever you link workbooks, you make it so that one workbook is dependent on the other.The dependent workbook is the workbook that contains the formula that links it to the other workbook.Linking two worksheets together means using references to cells in an external worksheet to bring data into your worksheet.Consolidating means to combine or summarize data from two or more worksheets.
A tedious task that befalls many Quick Books users is getting data from accounting reports into other spreadsheets.
The first way is to simply embed the Excel table or chart into Word and you will get a snapshot of the data at the time you embedded the chart.
The second way is to link the data and chart to its original Excel file.
The worksheets do not have to be in the same workbook.
In this article, we are going to learn how to link and consolidate worksheets.