Create a drop down list with autofilter??

[roughleg]

I need a drop down list on one worksheet that reflects rows of data on a different worksheet that need data entry. Can autofilter be used in a formula to produce a list that can be entered as the source in data validation? The filter would be for blanks in column D and the list would be generated from results of the filter in column A. Any help would be greatly appreciated.
Skip

 

[roughleg]

I probably should have been more descriptive in the subject line.