Automated Excel Sales & Inventory Sheet

I need a clean, future-proof Excel workbook built from scratch that turns my raw data into a clear Sales report while also keeping day-to-day inventory under control.

Scope of work
• Create a main Sales Report sheet that summarises daily, weekly and monthly figures—pivot tables and easy-to-read charts are welcome as long as they refresh with one click.
• Add an Inventory sheet with:
– automatic stock level updates driven by sales and purchase entries
– visible supplier details beside each SKU for quick reference
• Link both areas so any sale instantly adjusts inventory, safeguarding accuracy.
• Keep formulas, named ranges and (if needed) VBA macros well-commented so I can tweak thresholds or add products later without breaking the model.

Acceptance criteria
The file should open with no errors, recalc in under five seconds on 10,000 rows, and deliver correct stock counts after a sample sales import I will provide.

If you have a smart layout idea or a time-saving macro trick, feel free to suggest it—clarity and reliability are the priorities.