Excel Workbook Consolidation & Chart Creation

I have three Excel workbooks that need to be merged into one. In addition to simply compiling the data, I need the final workbook to summarize the information using bar charts. Specifically, I'm interested in visualizing year-on-year growth comparisons.

Ideal Skills and Experience:
- Expert in Microsoft Excel
- Proficient in data analysis and visualization
- Experienced in creating and interpreting bar charts

Please summarize the year-on-year growth using annual totals.