Excel Help - Pick from list

[UnworthyBean]

Hopefully someone who knows a bit about excel will be able to help me out here.

I have a spreadsheet with various headings - Lets say Red Shirts and Blue Shirts and then various names underneath them. I'd like a main spreadsheet that I can pick from a list of Blue and Red, Then it would show me all the names relating to this. Is this possible in Excel?

I know my way around Access and this is simple, But this needs to work on Macs too which don't have Access to Access (see what I did there? )

 

[UnworthyBean]

https://docs.google.com/spreadsheet/ccc?key=0Aljf3hJZmCQBdGV3aWMzNEp5cTJCU21mdzZZRlpMdkE&usp=sharing

A very crude example there.

Data is in columns C,D,E and in column A i'd like to be able to pick from a drop down box of Yellow, Red and Blue and then underneath it would show the corresponding data.

Trying to get thoughts from my head into words is difficult!