Save values for certain entries/rows across entire workbook

Hi, everyone. So I am in charge of temperature/health screening at my office for our return-to-office operations, and each day I have to log each person's information, take their temperature, and ask some screening questions. I have an Excel workbook with a different sheet for each day that I am logging all of this into. Obviously some of the information will change for each person each day, mainly their temperature, but their basic information (name, phone number, etc) stays the same no matter what. I wanted to know if it was possible to get Excel to recall/remember their last name (column A) and then automatically pull-in the next 5 columns of data that was entered previously (those all stay the same as well)? The issue is that it is not the same exact people coming in each day, so I cannot just bulk copy and paste the list from one day to the next. Thanks in advance for your time!

Originally Posted by oeldere

Why not all data in 1 worksheet?

It makes it a lot easier to analyse.

I need to have the responses to each of the screening questions documented daily, so having each person's name repeated a bunch of times on 1 worksheet is not really conducive to being able to easily view that data.