Copy from Excel to Powerpoint to create a report

[PSL]

Hi All,

As part of my job I'm required to create and update reports from a set of data on an Excel spreadsheet. The report has standard sections like Topic, Title, Date, Ref. No., Summary, Key Words and Detailed Finding. Details about each section is as follows:

Topic: The overall topic of the report. Typically a word or two
Title : Next level details. A sentence
Summary: 2 - 4 points with the main points of the report
Keywords: This has two sections; Financial and Non Financial. These are like hashtags and can be from 2 - 5 under each sub section.
Detailed Findings: This is the most important section and one which needs to change frequently. Each finding is represented as Finding, Summary and Details (bullet points ranging from 1 to 6/7). The excel would have an exhaustive set of findings from which I would need to select 4 that need to be shown in the report. The overall pool can increase as time goes on, but the total number that needs to be presented on the report remains 4.

I've attached the following sample files:
1. Report Format - The ppt format of the report and how the final outcome looks
2. Report Excel - This is where the data is stored and edited to create the report.

Looking to create a macro that can generate the report from the excel into the report format in ppt. I've made some minor excel macros before but wasn't sure if it's possible to create a macro that talks to both excel and powerpoint with all the formatting involved. I'm open to exploring the possibility of changing the template if copy into this would prove to be too challenging!

Look forward to any ideas! Thanks :-)

Note: I wasn't sure if this should be posted in the Excel or Powerpoint section, so do let me know if it would make more sense in the Powerpoint section.