I am looking for an advanced Excel specialist (Power Query, VBA, or data automation) to develop a tool that automates the inventory tracking of activated carbon used in a mining process. Currently the process is handled manually using multiple Excel files from different operational areas. The goal is to build a solution that automatically consolidates the data and generates weekly and monthly reports. Data Sources The system must integrate information from: 1. Daily plant inventory reports (Excel) 2. Shipment and movement records provided by security personnel (Excel) 3. Moisture and processed carbon reports from another plant (Excel) 4. Monthly report of carbon inventory in process columns (Excel) The solution should: • Automatically import source files • Clean and standardize the data • Consolidate movements into a central database • Calculate inventory by process stage • Allow users to select date ranges for weekly reporting • Generate an automated inventory matrix and dashboard Movements must be categorized by process stage: • Yard (Patio) • Columns • Shipment • Return • Fines • Samples • Vault • Precipitated material Expected deliverables • Automated data import • Consolidated movement database • Automatic inventory calculations • Automated weekly reporting • Dashboard or summary visualization Preferred tools • Advanced Excel • Power Query • VBA (if necessary) • Power BI (optional) Additional information The main goal is to reduce manual work and minimize errors, allowing the system to be updated simply by loading new source files. Please include examples of Excel automation or data consolidation projects you have completed.