Creating report from excel data

Hi ,

Apologies for being a complete Newb for this question.

I have to generate a template in either word or excel (preferred) that I can generate a summary report for customers, which needs to populated from data in external excel files.

how do i create areas where I can select data from the external excel sheet (with multiple tabs) and import them as a chart or data that I can create a chart from?

The data I want to import is contained in something like the example attached.  Unfortunately I cannot get CSV or XML versions.

Please let me know if there are more specifics that I need - ideally though there are going to be multiple entries and the template will be reusable as there are multiple clients that will each need their own report from their own data.

I thought about setting up an SQL database but I think that would be messy and time consuming.  I have also tried an MS Query, but i got an error saying that there were no tables in my xlsx file??

Thanks in advance