Help with Drop list of / automated population of staff

Hi, I have been using Drop Lists for a while, and now would like to move forward in my abilities in Excel.

I want to make a drop list that once you choose a manager then the staff are automatically listed and there stats.

I know I could use a Pivot Table, but I want to work with the Data, pulling it as I require. In other words I want something more flexible.

I just need to know what commands I would need to use. I will try and build the Excel sheet myself, until I get stuck. I am not asking for someone to build it for me, as I will never learn otherwise. But if I get stuck I will post the worksheet for assistance.

Many thanks for your assistance in advance!!!

Incheye