I have several sheets that are price listings. My goal is when customers enter a quantity in column F for the item they want to purchase, the corresponding row with all the info for that item (item #, description, price, quantity and total cost) will copy to another sheet titled Order Summary where they will fill out billing and shipping info and see all the items they are ordering from the various pricing sheets.
This allows the customer to submit one sheet rather than the entire pricing guide. I then want it to total all of the copied rows to show the total price for their purchase. How to set up this type of functionality in Google Sheets?