Find and Copy

I need some help getting a macros created. (Hopefully it is somewhat basic/easy for someone who is not a beginner like me. I will include the excel file as a template.

I have two tabs, TEAMS and ROSTER. I need to be able to match a name from ROSTER (column B) to a name in TEAMS (unknown row/column) and put the assigned supervisor (row 1) into the ROSTER tab next to the employees they belong to.

I have included comments on the excel file I am attaching. If you need further explanation, feel free to email me.

Thank you ahead of time for any time and effort you all may put into this process.