Streamline Valet Payroll Sheet

I run a valet parking company that staffs roughly 400 events every year and my entire payroll workflow lives in Google Sheets. Right now everything is entered by hand—employee hours, event details, commission calculations—and each week I copy last week’s tab, paste in new information, and watch the formulas fall apart.

Here’s what I need:

• Automate data entry so I’m no longer pasting into fragile cells. A simple input sheet, Google Form, or Apps Script that feeds the master file would be ideal.
• Reorganize the current layout into a clean, reusable template that can handle events of different sizes without shuffling rows or columns.
• Fix every broken cell reference and lock critical formulas so the calculations for hours, overtime, tips, and commission stay intact no matter how many events I add.

Acceptance criteria
1. I can duplicate a blank weekly sheet and start typing (or submit through a form) without touching any formulas.
2. Payroll totals, commission splits, and per-event summaries update automatically.
3. No #REF! errors appear after I add, delete, or sort events.
4. Solution relies only on Google Sheets/Apps Script—no external paid add-ons.

Share a copy of the improved file plus any scripts, along with a quick Loom or written walkthrough so I can keep it running long-term.