My Christmas Grotto Staff Roster Needs the Help of an Excel Expert...

Dear Excel Community,

I run an events company operating Christmas grottos throughout the UK. Key to what we do is the rostering of staff.

I have an Excel template ('Example Roster 2013' attached), into which on the first tab I put the opening hours of grottos and it will populate the correct shift patterns for Santa and his Elves.

We then manually input the initials of the employees who will cover each shift resulting in a roster which tells us who is working and when.

What is does not do is allow me to automatically generate individual hours sheets for each staff member based on where their initials appear in each time slot. Currently, we are manually creating these sheets by reading the initials off each time slot and inputting the shift into a ('Staff Member Hours Template.xls' attached).

The tab marked WK34 is filled out as an example.

Can anyone create a automatic process for me?

Kind regards,
Matthew