Can excel find data in a sheet, if that data sometimes may not exist/be in the same cells?

I am making a sheet at my work that basically sums up stats about staff each week. However, the internal source I pull the raw data from only shows employees who actually worked on a given day. My final sheet will show daily data and weekly stats.

I am trying to find a way to create a formula that will match that employee's name with their data on the raw data sheet and pull it into the finished sheet. But it will not be in the same cell each time. I am trying to avoid hand-tranferring the data if possible.

What I really want is a formula that will tell it "if you see Jane Doe, put the data two columns to the right of her name into this cell."

Excel LTSC MSO Version 2408

English language, Windows desktop, beginner proficiency