Copy rows from one workbook to another based on criteria

[Huggheez]

I have been struggling to setup these two workbooks for a bit now, and I can't for the life of me figure out a formula to do what I need to do.

Essentially, I have one workbook that contains a list of purchase records for my company, sortable by Date, Vendor, Price, etc. and one workbook that has a sheet for every vendor. What I need is a formula that will search column B for a vendor, Allied Waste for example, and transfer all the information within the rows for every instance that vendor is found to the new workbook.

This is basically just a way where I can input information once in one workbook, where the sheets are divided by month, and the info will automatically transfer to another workbook, where the sheets are divided by vendor.

Any help?