Automated Excel tables

Offering extra earnings. You need to develop tables for quick creation of the invoice for the client, keeping the history of orders of each client, calculating the total quantity of goods ordered by all customers. List 1: list of goods and their price. LIST 2: template of invoice with a cap The name of the client, the date of the order, the date of the desired receipt of the order. Column 1 is a fast set of niamation (that would quickly find the name of the goods with LIST 1 on the first letters of the input) and automatically substitute the price of the goods column 2. Column 3: possible discount in percentage and in column 4 price with the specified discount. Column 5: Amount before discount. Column 6 after the discount. In the result line: the amount before the discount, discount, soup after the discount, VAT, everything. Page 3-100: Each sheet is the history of each customer’s invoice. After creating through the LIST 2 template, each client’s order is copied to the Client’s Sheet. LIST 101: A table with a list of all product names, price, quantity in all orders (when you enter the customer's order, the number of ordered goods by name that the customer chose is automatically added to the total number in List 101. How much is that possible in the Excel??