Healthy Meal Subscription System

i have a healthy restaurant and i want a system to manage subscription and daily meals and kitchen orders
I want a fully automated Excel file or python
Sheet 1: Subscribers

Columns: Name | Phone Number | Subscription Type ("how many grams of protein and how many grams of carbs") | Number of Meals | Days Remaining (should decrease automatically every day) | Customer Notes (e.g., no pasta, etc.) | Pepsi or No Pepsi | Number of Snacks | Customer Location (I will fill this sheet myself)

Sheet 2: Daily Orders

This sheet should be generated automatically. It should take:
* Customer Name
* Subscription Type (e.g., 100g, 150g, or 200g protein and carbs)
* Dish Name (based on a daily menu that I will provide)
* Snack
* Pepsi or No Pepsi
* Customer Notes
Sheet 3: Cooking Schedule
This sheet should calculate total grams for each dish and apply a formula for chicken loss after cooking (45%).
Example:
Sheet 1 - Subscribers:

Muhanned | 055555 | 150g protein | 200g carbs | 2 meals | 6 days | no pasta | Pepsi | Rocca Salad | [Google Maps location]
Sheet 2 - Daily Orders (auto-generated):
Muhanned | 150g Butter Chicken | 200g White Rice
Muhanned | 150g Tikka Chicken | 200g Red Pasta
 | 1 Rocca | 
1 Pepsi
(Then for customer 2, 3, etc.)

Sheet 3 - Cooking Schedule ( Auto ):
200g Butter Chicken | 300g
 Tikka Chicken | 300g
White Rice | 200g
 Red Pasta |
 1 Rocca | 
1 Pepsi
(All totals based on customers’ orders, their salads, snacks, Pepsi, and applying the loss formula)