UserForm input data to multiple rows

Attached I have a spreadsheet with a user form to capture orders.

I have got the form working as far as, each piece of data will go into the right column heading. However because one customer will order multiple items I cannot work out how to get the items to list in one column a row at a time.

My idea is that each multipage and all the data entered (zero if blank) will be dumped into the spreadsheet in its rightful column in a list as displayed in the form, as each value in the list represents the weight band aligned to it.

Maybe I cannot do it as it is currently set up, so any other ideas/suggestions welcome.

Thanks

Yes sorry, numbers will be entered into the form they represent the quantity to order for each KG weight band.

So the idea of the form is that the user will be on the phone taking an order and they can use the form to fill out all of the required fields instead of hand writing it on paper and then transferring to computer. The form has all the info each order placed needs, so then if all that data can be placed into a worksheet I can manipulate the data to find what I want at a later date.

Hopefully that makes sense.

Cheers

All the userform data will be placed into the Order Log sheet.

I have attached another copy of the spreadsheet with OrderLog sheet filled out as I imagined it would come from the forms data entry. It’s maybe not the best layout of a table but is the best way I could think of...

Cheers

Anyone????