Automated Excel HR Task Manager

I need a single, macro-enabled Excel workbook that streamlines three core HR functions for me: employee attendance tracking, leave management, and performance evaluations. For attendance, I want the sheet to grab automated timestamps—no manual entry—so VBA will have to capture the date-time stamp as soon as a name or ID is selected.

On the leave side, the file has to record the leave type and dates, show the current leave balance, and store an approval status that I can toggle from pending to approved or rejected. Ideally those balances update dynamically each time a new leave request is logged or approved.

Performance evaluations can be simpler: a form-style sheet where supervisors enter ratings and comments, with a dashboard that aggregates scores by employee and by department.

Please weave all three areas into the same .xlsm file with a clean navigation menu, color-coded status indicators, and protection where it makes sense so formulas and code aren’t accidentally overwritten.

Deliverables:
• A fully functioning macro-enabled workbook (.xlsm) with automated timestamp capture for attendance.
• Self-contained modules for leave tracking (type, dates, balance, approval).
• An evaluation input form plus summary dashboard.
• Brief setup notes so I can add new employees, reset yearly balances, and tweak evaluation criteria without touching the code.