Excel Logistics Model Optimization & Data Cube Integration

I have a partially built Excel-based logistics planning model used by our logistics team for weekly operations. The file is growing in size (~10MB) and needs optimization and scaling. I'm looking for an Excel expert to:
a) Workbook Scaling & Formula Optimization
- Expand the model to cover a full year of weekly sheets (currently only a quarter built)
- Review and refine formula logic, especially around summing logic but possibly data validation and conditional formatting if deemed necessary.
- Resolve issues with duplicated defined names when copying weekly sheets if appearing
- Explore grouping/minimizing vehicle rows by Vehicle_Grp for better usability across site users.
b) Stock Sheet Review
- Audit the use of INDIRECT functions across depot stock sheets to sum the weekly sheets efficiently
- Assess and improve grouping logic for SKUs and weekly data
c) Driver-Friendly Printouts
- Create a user-friendly way to print a vehicle’s job list by selecting week/day/vehicle
- Ignore blank lines and return only active entries.
- Potentially generate a weekly driver summary by name, if possible.
d) Data Cube Integration
- Extract and structure all relevant input data into a Power Pivot or Power Query data model (data cube/db)
- Enable trend analysis by customer, location, and collection frequency
Ideal Skills:
- Advanced Excel (Power Query, Power Pivot, VBA optional)
- Experience with logistics or operations models
- Strong understanding of workbook performance optimization
Looking to start immediately.
Budget type negotiable