Custom Excel Inventory & Orders

I need a well-structured Microsoft Excel workbook that acts as a lightweight inventory database and, from that same file, lets me generate both packing lists and simple sales orders.

Core requirements
• Inventory sheet: each row represents one SKU and must include the following columns exactly as written—Item Category, Supplier Information, Price, Description, UPC, and Cost.
• User-friendly data entry: drop-downs or data-validation for categories and suppliers so new items stay consistent.
• Order & packing interface: a clean form or secondary sheet where I can choose items, set quantities, and have the file automatically pull the item details and calculate totals. When I flag an order as “packed” the system should be able to turn that list into a printable packing slip.
• Stock updates: each confirmed order should deduct quantities from on-hand stock (a simple macro or structured formula is fine; no external databases).
• Reporting: a quick snapshot showing current stock levels and low-stock alerts.

Acceptance criteria
1. Workbook opens with no macro warnings other than the expected “Enable Content.”
2. Adding a new item instantly appears in look-ups for orders.
3. Generating a test order updates inventory counts accurately and creates a formatted packing slip ready to print on A4/Letter.
4. All formulas/macros are unlocked and commented so I can tweak them later.

If you’ve built similar Excel tools—especially ones driven by tables, Power Query, or light VBA—please mention it when you respond. I’m ready to start as soon as I see a clear plan and timeline.