Multi-Section Action Tracker with Gantt

I’m looking for a well-structured action-tracking file (in excel preferred) that can live at the centre of our non-conformity and engineering-change request workflows while still handling the odd small project or personal to-do list.

Key elements I must see:
• Sections that behave like independent workstreams.
• Inside each section, tasks and nested sub-tasks carrying these fields: Title, Notes, Priority, Responsible Department(s), Start Date and End Date.
• A live Gantt view where every task and sub-task automatically shades its scheduled timeframe.
• Conditional formatting so anything that rolls past its End Date without a “completed” flag lights up red.
• A front-page dashboard that pulls status counts, late items, and upcoming deadlines, all refreshed by simple macros to save clicks.

The data depth I need is moderate—enough to manage ownership and timing without drowning the team in forms—so the layout has to stay clean and unintimidating.

Please send a concise but detailed project proposal that outlines:
• Your preferred platform (Excel + VBA, Google Sheets + Apps Script, or another option) and why it fits.
• How you’ll structure the Gantt linkage and the overdue-item highlight logic.
• The macro functions you plan to include for day-to-day ease of use.
• An estimated timeline for delivery and any staged milestones you recommend.

If you have screenshots or short clips of similar trackers you’ve built, drop them in—I’ll review and get back to you quickly.