VBA to split/copy rows based on max quantities

Hi,

I have an order form that i would like to be able to split data in a row based on the quantities of certain items. Once the max is hit for that item i would need it to copy the remaining down until there is no more of that item.

Small items have a max quantity of 10
Large items have a max of 5

Sorry, if its hard to understand what i'm asking. I have attached a workbook with what is the beginning data and the end result of what ill be needing. I don't have much experience with VBA but i can learn quickly and adapt pretty easily. Any help would be greatly appreciated. Thanks.