I need a single Excel workbook that lets me monitor four different products from the moment they come into stock until they reach my customers each week. The file must show, at a glance, how many units I still have on hand, how many went out this week, and the exact date each order was placed. The only way I want to add customer orders is through a clean, user-friendly form—no typing directly into tables. When I open the form, I should be able to pick the product, enter the quantity requested, choose or type the customer name, and hit submit. As soon as I do that, the workbook should automatically: • deduct the quantity from the correct product’s stock balance • stamp today’s date (or the date I select) as the order date • log the transaction so weekly sales totals update themselves Because I issue product every week, the workbook should roll up sales per week for easy reporting, while still letting me dig into individual order lines whenever I need. A simple dashboard that highlights current stock levels, weeks of inventory left, and any negative balances would be ideal. I’m looking for something I can start using right away, so speed matters—ASAP delivery is part of the brief. If you plan to rely on VBA, Power Query, or any other Excel tools, just build them straight in; no external add-ins please. When you hand the file over, I’ll count the project complete once: 1. Each product’s starting stock can be entered in one place. 2. The form creates orders and updates every total correctly. 3. Weekly sales figures, order dates, and remaining stock populate automatically. This be graphed for easy viewing 4. There are no broken formulas or security prompts. If that sounds clear, let’s get it done quickly.