Create Dynamic Data Validation List based upon Criteria

Hi Everyone -

I am trying to create a pull down data validation list to only include a list of names that meet certain criteria.

My attached workbook has 3 tabs, Employees, Salaried, and Hourly. I have a seperate validation pull down list in column A on the Salaried and Hourly tabs. What I am looking for is to build a dynamic list of names that meet 2 criteria. On the Salaried tab list, it would only include a list of Employees that are "Salaried" and "Active". Similar list for Hourly tab.

Both list will need to dynamically "grow" as new employees are added to the Employee tab.

Any help is greatly appreciated.

Thanks,
Jim