Excel Order Tracking Solution

I need an Excel-based tracking solution for my orders.

Essential Requirements:
- V-Lookup or Pivot Table functionality
- Automatic updates through formulas for order status

Tracking Needed:
- Order status updates
- Shipping information: dates, tracking numbers, carriers

Data Visualization:
- Pivot tables
- Charts
- Dashboards

Ideal Skills and Experience:
- Advanced Excel proficiency
- Experience with data tracking and visualization
- Strong attention to detail and organization

Please see the attached file I'm currently working on.