Excel Task Management Dashboard

I need an editable Excel workbook that lets me oversee daily tasks across multiple departments in both Chinese and English. One sheet should serve as a master list where I can enter department names from my own predefined list, while a separate sheet automatically populates individual employee pages. Each employee page must capture task description, status (Pending / In Progress / Completed), start date, deadline, priority, and a notes area.

A third sheet will act as a simple dashboard that refreshes itself with bar charts showing:
• total completed tasks versus pending,
• task distribution by department,
• and a quick employee performance summary.

Please build in formulas and dropdowns so status, priorities, dates, and department names flow through the workbook without manual rewriting. I also need printable daily and weekly reports that keep the same clean, professional design and can be exported as PDF with one click. Keep the layout uncluttered, easy to navigate, and styled for both English and simplified Chinese labels.

Deliverables
• Fully editable .xlsx file with unlocked formulas
• Automated dashboards using bar charts only
• Print-ready daily & weekly report templates (fit to A4)
• Clear instructions inside the file for adding new departments or employees

If something is unclear, feel free to propose what you think is best practice; otherwise, follow the outline above so I can drop in my own data and start using the file right away.