I have an existing Excel workbook for inventory and order tracking that I want completely automated with VBA and wrapped in a clean, intuitive interface. Here’s the full picture of what I’m after: • A single-click workflow: users should be able to enter or import stock movements, generate invoices or purchase orders, maintain customers record, manage vendor database and instantly update every linked table. • A dynamic dashboard that shows real-time sales trends, current inventory levels, and order-fulfilment rates in clear, interactive charts. • Seamless OneDrive synchronisation so the file is always backed up and the latest data is available to any authorised user. • Invoice and PO generation powered by custom templates, automated numbering, and built-in email integration so documents can be sent straight from Excel without extra steps. • One click data update using userform, without opening the excel sheet. Please build the VBA code, forms, and connections that make all of this happen, and leave the workbook open enough for me to adjust branding or add new fields later. If you have ideas on improving speed or adding safeguards against data conflicts, let’s discuss them.