Order form - transfer and store of multiple orders in separate sheet

[BranAlex]

Hi All,

Hope you are all well and keeping safe.

Hoping someone can assist me.

I would like to have the order form in the attached (first sheet) populate the combined order spreadsheet (second sheet). Thus as I enter a customer's order amounts (in quantity) that these are then automatically populated into the combines larger second sheet. I need to be able to enter multiple customer orders and have these transfer over once entered/ complete. Thus enter an order, have this saved on the combined sheet and then be able to enter another customer' order, without overriding the previous orders.

Please help.

Many thanks.