Automated Excel Report Builder

I keep raw operational data in a series of Excel spreadsheets and need it transformed into polished, detailed reports I can hand straight to stakeholders. I’m open to whichever mix of SQL, Excel, and Word you feel will deliver the cleanest workflow—Power Query, Access, or even a lightweight SQLite back end are all fine by me as long as the end-to-end process is repeatable.

Here’s the scope I have in mind:
• Import my Excel spreadsheets into a small, query-ready data store.
• Build the SQL logic (joins, filters, calculations) that extracts the metrics I’ll specify once we start.
• Feed the results into a Word template that lays out tables, charts, and commentary automatically so I never have to copy-paste again.
• Provide clear, step-by-step notes so I can refresh everything myself whenever new spreadsheets arrive.

I’d like to see samples or screenshots of similar reporting automations you’ve completed and an outline of how quickly you can deliver the first working draft.