Creating individual student reports

Hi sorry for the late reply been busy at work!

So this is a sample of the excel spreadsheet i am working from.book3.xlsx
To explain the cream coloured data is their attendance code for the week mentioned in the header.
The sky blue is their score for the above week and the final 5 colums are the totals which need to be included in a report.

Is there anything i can do from this to create individual student reports that can be printed and put into the individual student files?

What would be even better is as well as the report containing the 5 end colums (the totals/averages) if i could include some kind of written statement bank which is given depending on their grade.!

Thanks again,
C1987