Logistics Dashboard & Data Automation

I need help turning my current Google Sheets-based shipment tracker into a reliable, visually driven decision-making tool. Right now the file has grown messy and error-prone; I want every data point checked at entry, seamlessly combined with feeds from other spreadsheets (and occasional Excel uploads), then surfaced through clean, interactive dashboards.

Your work will focus on three enhancements:

1. Data accuracy & validation – build fool-proof rules, drop-downs, and conditional checks so bad data never sneaks in.
2. Data integration – set up queries or App Script that pull fresh information from multiple sheets or external CSV/XLSX files into a single, structured source of truth.
3. Automated reporting – generate dashboards in Google Sheets (or connected Looker Studio if you prefer) that refresh automatically and show at a glance: shipment delivery times, order-fulfillment rates, and current inventory levels.

Deliverables:
• One master sheet with validation logic in place
• ETL or scripted connections for all incoming data sources
• A fully formatted dashboard tab with the three KPIs above, filterable by date, destination, and carrier
• Brief hand-off notes or a quick loom explaining how to maintain the setup

If you’ve built logistics dashboards before and are comfortable with formulas, QUERY, ARRAYFORMULA, pivot tables, Apps Script, or similar, I’d love to see how you can streamline this sheet.