Thanks for the mock up - very useful , however, with the data the way its laid out - nothing comes to mind quickly
hopefully another member may help - while i see if i can get a solution, but not simple for my knowledge

Shame its not laid out differently, then a pivot table would create the summary and possibly the order form