Teacher needs help

Hi guys,

I need your help on the following problem:

I've created an Excel document in which I can keep track on each of my students and their progress.

I have a main spreadsheet in which I enter their grades, remarks about attitude e.g.

Each student has their own spreadsheet in which they can only see their own grades e.g.

I want to add a function (macro) in which each student gets a link/e-mail/... (I don't care which way) with only their own spreadsheet. 

Is this possible?

I've added an example file in the attachments so you can see what I mean.

I want the "Jan" tab to share with Jan, and the "Joop" tab to share with him etc.

Thank you in advance!

Noud