VBA - Search Sheet 1 for text, reference corresponding cell, populate Sheet 2?

Alright, Excel Gods. I'm attempting to do something that's way above my pay-grade and I need some guidance.

I'm working with a basic schedule of projects, each with multiple employees working on them. Employees work on numerous projects at the same time. Sheet 1 is a list of projects with the employees assigned to them. Sheet 2 is a list of employees. Ideally, I want a macro that will search through Columns D - M in Sheet 1 for an employee name and populate Sheet 2 with the corresponding project from Column B, Sheet 1. If those projects list alphabetically, all the better.

I'm attaching a workbook with an example of what I'd like to see in sheet 2.

Thanks for any help you can offer!

Ryab

Thanks so much! This works perfectly!