Excel Spreadsheet for Client Product Orders

I need an Excel spreadsheet designed to handle my client product orders. The primary use of this spreadsheet will be to calculate totals.
I want a tab for Client List information inc. contact information. That client list should then be on each tab
1. Client list with check boxes for certain tasks complete.
2. Client list with Summer Product Orders (x product in columns)
3. Client List with Seed Order (x product in columns)
4. Client List with Fertiliser Order (x product in columns)
5. Client List with Pre Seeding Orders (x product in columns)
6. Client List with Post Emergent Orders (x product in columns)
7. Client List with Q4 Orders (x product in columns)
Product totals at bottom and calculating excess or deficit of product.
8. Products ordered Tab for Conference Orders / LPPG Orders / Std Orders / SOH these volumes to pre populate into the above tabs to calculate excess / deficit.

Ability to create a report or PDF by client of what they have on order prefer option of direct to email.

Easy to read format.

Key Requirements:
- It should record customer details and product information for each order.
- The totals should be displayed as 'Client Order Totals'.

Ideal Skills and Experience:
- Proficient in Excel with a deep understanding of its functions and capabilities.
- Previous experience in creating order tracking spreadsheets.
- Ability to design user-friendly and efficient spreadsheets.