Automated Excel Inventory Report

I’m looking to streamline the way I track stock levels by turning a series of existing internal spreadsheets into a single, button-driven inventory report. Right now, the data sits in multiple Excel files that are updated daily by different team members; what I need is a routine—whether VBA macros, Power Query, or another native Excel solution—that pulls those sheets together, cleans the figures, and produces a polished inventory snapshot ready for management every morning.

The core workflow I have in mind is simple: once the operator clicks “Generate,” your automation should gather the latest numbers from our internal workbooks, reconcile duplicates, highlight discrepancies, and output a formatted report (PDF and XLSX) showing on-hand counts, reorder points, and variance against safety stock. Speed and reliability are critical, as this report drives our purchasing decisions.

Deliverables
• An Excel file (or add-in) with the automated inventory report generator
• Clearly commented code or queries so we can adjust ranges and file paths later
• A brief hand-off guide or walkthrough video demonstrating how to run and maintain the solution

Acceptance Criteria
• Report completes in under two minutes on a standard office laptop
• All formulas or scripts run without external add-ins beyond standard Excel/Power Query
• No manual copying or pasting required once the process starts

Everything lives inside our local spreadsheets for now, but I’d like the structure to be flexible enough that we could point it to a database or cloud folder down the road. If this sounds like your area of expertise, let’s make our inventory reporting truly one-click.