how to list all matched instances of a value in excel

I am in a pickle. I am trying to build an order guide and want everything I order from one vendor, put onto a separate sheet. That way I can see everything I order specifically for each vendor when I go to place my order, rather than going through my whole list searching. Sometimes I bring on new products from vendors and need the list to automatically update as well.

Currently my formula looks like this:

=IF(ISERROR(INDEX('Order Guide'!A1:B240,SMALL(IF('Order Guide'!B1:B240=$A$1,ROW('Order Guide'!B1:B240)),ROW('Order Guide'!1:1)),2)),"",INDEX('Order Guide'!B1:B240,SMALL(IF('Order Guide'!B1:B240=$A$1,ROW('Order Guide'!B1:B240)),ROW('Order Guide'!1:1)),2))

But it isn't working. Where am I messing up?

Listed here is my current spread sheet: Photo of current spread sheet

Thank you,