Can i link drop down lists?

Evening happy campers,

In my workbook, Sheet 2, Range A1:A10 is a list of names - the range has been called =Names, to allow me to use a drop down list on sheet1.
These names are the area managers.
I also have a list of employee names in column D, for every cell in Column D, the adjacent cell in Column C has one of the managers names from A1:A10.

On Sheet1 i have added a drop down list in Cell A1, set from the range =Names.
What i would like is the following:

User selects a name from the drop down box in A1, then in C1 they have another drop down list that shows all employee names.

Have loaded a sample and tried to explain there also

Thanks in advance!!

Galvinpaddy