Help needed with Markbook

Hi all,
I am a Science teacher and am currently trying to arrange a spreadsheet that we can use in a large secondary school to track pupils progress.
(I have attached what I have done so far)
There are 5 different Assessment Focuses (AF1-AF5 each given a new sheet). Each AF has 6 levels. At each level there are different statements that must be met in order to achieve that level.

What I want to achieve (If at all possible) is to be able to select the statements at each level (By the little round buttons, not sure on their name)in each sheet and then on the main sheet to have a summary of the level achieved for each AF.

E.g. If all of the statements were met at level 3, and 2 were met at level 4 under AF1 then a Level 4 would be awarded which would show on the pupil sheet in the AF1 column.

I am quite good with Excel but this one has stumped me.

Any assistance would be massively appreciated.

Olly