Formula to create table or list based on team members

Hi all,

I'm looking to create a team project view. I have a list of projects with various team members assigned on one sheet. On another sheet, I now need a view that shows each team member and the list of the projects they are assigned to. Hoping to do this via a formula. Simply using a filter on the first sheet doesn't work because the project names are not in the same row as the team member names.

Sample file attached which hopefully explains it easily. Thanks in advance for any help!