Excel 2007 : Auto select and copy rows containing a cell with a specific value

Hi all.
I have a sheet like a database filled with entries like bellow:
Company.......Brand.......Info1.......Info2.......Info3
Comp.1.......Brand A.......001.......252.......333
Comp.2.......Brand B.......001.......252.......333
Comp.2.......Brand B.......001.......252.......333
Comp.1.......Brand A.......001.......252.......333

My quest is to make on another sheet a drop-down list with the brands from the database (duplicate values removed), wich, when you select a brand, all rows containing that brand will be displayed or copied under the drop list.
But, when i select another brand, all rows displayed from the previous query will be erased, and replaced with the new ones.

Can anyone help me? I atached the file. Thanks

Nicely done davesexcel.

THANKS A LOT!!