Jon Palmer shows how to use the Excel Data Model to connect multiple sources, such as Workbooks or Worksheets, and then use that integrated data source to create a PivotTable or PivotChart. By using the Data Model, you will be able to analyze data from several sources at once. In addition, by creating connected data sources within the Data Model, you can eliminate the need to use VLOOKUP.
