Learn how to create Pivot Table in Excel & how to convert it into a Pivot Chart. This way summary report of data can be created as Pivot Table for easy ref.
Consolidate Data – In Excel Files – Create Summary Report
Learn how to Consolidate Data in Excel to Summarize data from different worksheet or workbooks.The build in option is more advanced to consolidate in Excel & better than Pivot Tables.