Need create Quotation file in Google Sheet

Hi, .. I need Google sheet file like Microsoft Excel, but in google sheet I can open and work on it from anywhere. Required to create a quotation file on google sheet the Quotation table should contain: Image - Category Type - Cost - Total Cost so when i just write the first word or two latter from one of the products or services that i am provide, it should appear like a drop list. so i can choose it then automatically the product photo appear and the cost and quantity 1 and total price. so when i change the quantity, the total price will change too. Then go to the second row and the same way ... Write the first word or first two letters about a product or service and prove to me and then chose .. in the end I can write discount% .. and displays under the total and discount and net after discount Of course with regard to products, pictures and prices .. i will provide and write. So you repeat, for example, 50 products, pictures and random price .. so i can change photos and prices later and I can add any addition of a new product later All required on Google Sheet no in Excel if you have any previous google sheet projects. please let me see Thank you