Project Task Tracker Excel Workbook

I need a clean, easy-to-use Excel workbook that lets me stay on top of my project tasks at a glance. The core requirement is Task assignment, and I want every task organised By project phase.

Here is what I have in mind:

• A front-page summary that automatically pulls totals for each phase so I can see how many tasks are open, in progress, or done.
• Separate phase-specific sheets (e.g., Planning, Execution, Wrap-up) where I can list individual tasks, owners, start and due dates, and current status.
• Drop-down menus and colour-coded validation to make assigning and updating tasks quick and fool-proof.
• Simple built-in formulas to count outstanding items and flag anything overdue.

The file should be self-contained—no macros or external add-ins—so that anyone on my team can open it in standard Microsoft Excel without security prompts. If you know a clever way to keep things tidy with Tables or PivotTables, feel free to incorporate them.

Future-proofing matters to me, so please structure the workbook so I can later bolt on deadlines tracking or progress monitoring without starting from scratch.

Deliverable: a finished .xlsx file with dummy data to demonstrate the flow, plus brief notes explaining where to add or edit phases and tasks. Let me know your estimated turnaround and any questions you need answered before you begin.