Excel Timesheet & Payroll Builder

I’d like a single, well-structured Excel workbook that lets me record each employee’s hours, automatically roll those hours into an attendance sheet, and then calculate gross pay in one step. Right now, I’m not tracking hours at all, so the file has to be easy for a beginner to start using on day one—simple data entry, clear formulas, and no external add-ins.

Core flow I have in mind:
• Daily or weekly time entries feed an attendance log.
• Attendance data feeds a payroll sheet that applies my pay rates, overtime rules, and any standard deductions.
• All calculations stay inside Excel—no macros are strictly required, but if VBA will streamline the experience I’m open to it.

Deliverables
• An unlocked .xlsx (plus .xlsm if macros are used) containing the time-tracking, attendance, and payroll tabs already linked.
• Brief, step-by-step instructions inside the file so anyone on my team can maintain it.
• A short test dataset so I can verify that totals and payroll figures reconcile.

There’s no hard deadline; quality and future maintainability matter more than speed. Let me know if you’ve built something similar and what approach you’d take so I can hit the ground running.