Compile data from one sheet to another

Hello all you excel experts!
I know my question is not a hard one for those of you out there with great skills, but I can't get this done by my self (tearing my hair of soon! )

I have an example list that I made to simulate my problem. In sheet1 (Products) there is a list of products (fruits) and sheet two (Order) is like an order confirmation. Lets say i fill out the first sheet with the different quantities a customer want to order. I would like to have this productorder automatically compiled in a nice list with total cost summarized at the bottom of the order sheet when the order sheet is opened. I attached the file for you to have a go at =)

There may offcourse be a question similar to min already answered, but I could not find one =( If possible please guide me.

Compile-test-file.xlsx
Many, many thanks from a desperate girl!