Search products below par and create an order list

I am new to Vba and macros. I would like to have the macro search for items that need to be ordered and print them on a sheet as a list. The list will be sorted by vendor, with subcategories for items by case or by bottle. Column K on my sheet says "order" when an item falls below par and column L shows how many to order. In column L "case order" shows for items ordered by the case. Here is a small sample of the sheet I am working with. There are 3 other sheets in the same workbook that I eventually will set up in the same way. Attachment 433523

Given the example sheet I provided, I would like the Output document to look like this.....

MSW order

Cases
Ketel One

Bottles
1 Svedka citron
2 Svedka Vanil

United

Cases
none

Bottles
1 Belvedere