Extracting data from complicated table....

Hey all, 

Below is a table I have created for tracking info for a special-needs child, the staff member caring for them, the shift, the behaviour and the score (0-5).

The Staff cell for each day/shift has a drop down box with a list of staff member names.

The cell to the right of the staff name would have a value from 0-5 with 0 showing no behaviours up to 5, which would indicate the behaviour was 100% during the shift.

What I'm trying to extract is information such as...

1) For a given behaviour, what shift sees the best and worst - trying to measure if the child has more issues in the morning for instance, verses the afternoon or night.

2) When it comes to the staff member working the shift, who is seeing better or worst behaviours - trying to measure whether the child may have an issue with or be reacting to a staff member more than another. This could come down to staff competency or personality clash.

3) It would be great if I could work out the above by day of the week - as the child is able to select what they would like to do, this could indicate weekly cycles or potential patterns in the childs behaviour as well.

While this one starts on March 16th Monday, I would be creating future tables starting at the first day of the month. Possibly a separate Excel file for each month, so the files remain manageable.

I'm normally ok with working out the info i need and creating formulas etc... but this one has me a bit stumped.

I had started to literally create a 'Reference Data' tab where I was cherry-picking specific cell references from the below table to create a another table, duplicating information but in a different table layout... it is getting exhausting this way and I'm still no closer to being able to work the data.

Hoping someone has some relatively simple fixes using XLookup or something like that.

The information is being used to help with funding and activities, so it's quite important I can get this to work. If it means redesigning the table...I'll have to do that but this is the format my partner was trying to use for ease of reporting the shift/staff/behaviour/score details.

Regards