Use and auto-sort names from a master list, with multiple columns under every name

Reading your question again, you can check if this is a result you could accept.

It is a little differant aproach.

I changed the headers in your file / I changed the name of your sheet (Ark).

After that a VBA code to get all data in 1 sheet (output).

After that a pivot table to analyze the data.

I just took all data (it also can be showed per date).

Please reply.