Automated Marketing VBA Reports

I need a seasoned Excel VBA specialist to build a macro-driven reporting tool that automatically compiles and updates two core report types for my digital-marketing agency:

• Marketing performance reports
• Customer analytics reports

The script should pull fresh data from both our social-media platforms (Facebook, Instagram, LinkedIn, X/Twitter—via their APIs or exported CSVs) and our internal SQL-based database, merge and cleanse it, then populate a formatted dashboard in Excel. Charts, KPIs, and trend summaries must refresh with a single click or on a timed schedule.

Key requirements
• Written in clean, well-commented VBA, compatible with Office 365.
• Connection routines that handle API tokens/credentials securely.
• Error handling so failed pulls don’t break the workbook.
• Simple parameter panel where my team can choose date ranges, channels, or campaigns before running the macro.
• Final file delivered as a macro-enabled workbook (.xlsm) plus unlocked code modules.

Acceptance criteria
1. Hitting “Refresh Reports” fetches the latest data and updates all visuals in under two minutes on a standard laptop.
2. No hard-coded paths, passwords, or tokens inside the code; these must be read from hidden named ranges or environment variables.
3. All formulas, pivots, and charts remain intact after multiple refresh cycles.
4. Clear, step-by-step hand-off notes so my in-house analyst can tweak field mappings later.

If you have examples of similar automated Excel dashboards—especially ones integrating social-media data—please share screenshots or a short screen-capture. Looking forward to streamlining our reporting workflow together.