Dependent Drop Down List

In the attached worksheet, on the "Data Entry" tab, when the user selects the Project (Column A), I need a drop down list to appear that only selects the subcontractors that are relative to that project in Column D (based on the "Subcontracts" tab Column B.)

Then I need for the Subcontractor name from the "Subcontracts" tab to populate column E automatically on the "Data Entry" tab.

For example, if project 660000227 is chosen, column D should have a list of 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15. If I choose number 1 - then R.D. Lambert would be popuulated in Column E.


Thank you!