Excel Multi-User Inventory System

I need a robust Excel-based solution that lets several team members work simultaneously with our inventory data. The core of the workbook must handle complete order management—logging incoming and outgoing orders, updating quantities automatically, time-stamping each transaction, and flagging anything that requires attention. Alongside that, I want a clean, searchable supplier database built in so we can pull contact details, lead times, and pricing without leaving the file.

The layout should be push-button simple for non-technical staff, so well-designed forms, drop-downs, and protected sheets are a must. If you prefer VBA or Power Query to streamline the flow, feel free; just keep macro security in mind because the file will travel between colleagues. I will host the file on a shared drive, so any locking or concurrency tricks you normally use to prevent clashing edits are welcomed.

Deliverables
• An Excel workbook (.xlsx or .xlsm) with separate, clearly labeled modules for Orders and Suppliers
• Automated routines that update order status and supplier references without manual copy-paste
• User guide or quick screencast showing the key workflows and how to add new suppliers

I’m open to future enhancements such as stock-level tracking, but for now the focus is solid multi-user order processing and supplier visibility. If this fits your skill set, tell me how you’d structure the workbook and estimate how quickly you can turn around a first draft.