Copy Values from Excel Form

I have been tasked with developing a new system to track evaluations. The idea I am using is utilizing Microsoft Forms and excel to simplify entering data. This works well, but particular data from the form I would like to split into sections (attendance, comments on performance, and mental health status).

My goal is to organize attendance by week and particular names so that they filter accordingly. I also want it to have a function that automates, so as the form fills with more data, it is auto-entered into the appropriate fields. I've tried a multitude of functions, but I haven't been able to narrow it down. I've attached a few pictures to show how the data laid out.  Thanks to all that help.