I need some help.

Ive got a very large woork sheet and would like ot break it down so I dont
have to do alot of typing. Here is what I would like to know if its possible.

1. Ive created a number of Dropdown list, but wanted to know if when I
selected a particular item from from list in cell B2 cell D2 would
automatically be populated by the correct list? e.g. Department Heads are
selected in B2 only the pre-assinged names would appear in a drop down list
in cell D2. and so forth.
2. How do I do a sort by text or would I need to put a number infront of the
text for it to work. eg. Say I had a sheet of 1000 employess by department,
positions,yrs of service and so on. How could I sort out only the Department
Heads or say job lvls?

Ive tried many different formulas but they would work for part but not all.
Help would be greatly appreciated.