I have a workbook, and the master sheet has data in many columns and rows.
Column B is the type field, and every row has been given a type of either,
Direct, National, or Dealer. The master sheet will be updated regularly
(weekly or monthly). I want to minimize the work required to update the
workbook, so the ideal solution is for just the master sheet to be updated
manually, and the rest of the sheets update themselves accordingly.

I want to have 3 additional sheets, one for each type. I'd like each sheet
to automatically list rows of their corresponding type from the master
sheet.

For example, the Direct sheet will show all rows from the master sheet that
have the type, Direct.

Master sheet:
midwest Direct 12000 500 0 500 12500
northeast National 315 1354 0 454 55521
southwest Dealer 14540 200 2 11250 111250
midwest National 13245 321 0 312 748678
midwest Direct 23546 324 0 123 67898
northeast Direct 315 1354 0 454 55521
northeast Direct 343 2678 0 433 234234
northeast National 315 1354 0 454 24234
southwest National 4342 200 2 33423 234423
southwest Dealer 3424 200 2 45664 67898

-----------


Direct Sheet should be:
midwest Direct 12000 500 0 500 12500
midwest Direct 23546 324 0 123 67898
northeast Direct 315 1354 0 454 55521
northeast Direct 343 2678 0 433 234234


------

This example is very minimal, compared to the actual amount of data on the
master sheet. I have been looking up information of Lookups, Index/Match
and Advanced Filtering, but I just can't make it happen.

Does anyone have any ideas?

Thanks.

-Sean