Auto-populate workbook based off dropdown in another workbook

Hi there!    I think there is an easy solution for this, but I cannot figure out what function to use.  We use excel to track study recruitment progress for a research project. We have contact i...