Facturation excel/ Excel invoices

I have already excel invoices for wholesale customers, maybe 12-15 different ones. I want some automatic formulas to create a new worksheet with new invoice number and date, and write some data automaticaly in another sheet to see monthly and yearly orders for each specific customer, and see variations, graphics etc from those orders When a customer send me every Monday a form with the order by email, the information contained in their form should go on the invoice worksheet easily without me rewriting every line. Or if I receive the order by phone, I can enter it manually. I want to be able to have all orders received/entered weekly totalized in a Production Sheet so I can know what are the needs for Production for this specific week and print the Production sheet. I want also to be able to manage those sheets and invoices from google drive account so they have to be compatible with google sheets Then I need some excel sheets to calculate ingredients quantities needed for my products Example Spicy Fresh Sausage Recipe AMOUNT : 10kg salt : 200g garlic : 50g pepper : 80g cayenne : 100g paprika : 75g water : 1L You can provide me a general template for Recipe, and I can enter myself all recipes duplicating this template into many different sheets. I could give you a list of all spices and materials used, and for each specific recipe the visible part of the list will be with items where I write something (like for our example of spicy sausage, there is no allspice in it so we dont want to see allspice on spicy sausage recipe sheet, its easy, empty values wont be displayed) same thing for material part of the recipe sheet. I need a search system to find the right worksheet fast (we have dozens of differents products) and very important, the ingredient quantities must be accorded to the product amount. ex: if I write 100kg in the amount case, we should see 2000g salt, 500g garlic, etc etc I also need another file for Material Cost calculation based on weekly ingredient and material costs. For same example of spicy sausage Material salt : 200g garlic : 50g pepper : 80g cayenne : 100g paprika : 75g water : 1L 10kg * pork meat 80% 1,5 * pork casing 29-32 2 * labour unit 5 * plastic vaccuum bag 8*20 0.25 * smoke unit In another sheet I will enter weekly price of spices and material, something like garlic : 15$/kg pepper : 12$/kg allspice : 35$/kg ...... porc 80% : 4$/kg labour unit : 15$ etc You can provide me a general template for Material Cost, and I can enter myself all recipes duplicating this template into many different sheets. I could give you a list of all spices and input materials used, and for each specific recipe the visible part of the list will be with items where I write something (like for our example of spicy sausage, there is no allspice in it so we dont want to see allspice on spicy sausage recipe sheet, its easy, empty values wont be displayed) same thing for material part of the recipe sheet.