The Consolidate command lets you combine data from multiple sources. Excel lets you do this in two ways:
Consolidate based on the arrangement of data. This is useful when data occupies the same number of cells in the same arrangement in multiple locations (Figure 3).
Consolidate based on identifying labels or categories. This is useful when the arrangement of data varies from one source to the next.
With either method, Excel can create links to the source information so the consolidation changes automatically when linked data changes.
Select the cell(s) where you want the consolidated information to go (Figure 32).
Figure 32. Select the cells in which you want the consolidated ...