Spreadsheet Order Entry System

I want to keep my order tracking lightweight, so I’d like the entire solution built in a spreadsheet environment (Google Sheets or Excel—whichever you’re fastest with). Users will open a clean form-style interface, fill in customer details, product, quantity, price, and hit “Submit.” Those entries should drop into a master table behind the scenes without exposing formulas or letting anyone accidentally overwrite data.

From that same file I also need a concise dashboard or pivot-style report that totals sales by day, week, and product so I can spot trends at a glance. Because all data will be typed in manually, the form must include basic validation (no blank mandatory fields, numeric checks on quantity/price, date picker, etc.) to keep everything consistent.

Deliverables
• Spreadsheet file with protected master table
• User-friendly entry form wired to that table
• Auto-updating summary/report sheet with simple filters or slicers

If you have tricks for making the form even smoother—or ways to extend the reporting in the future—let me know when you respond.