Macro to transfer data from main sheet to sub sheets

Hi

I need some help with the attached workbook.

I have macros on another sheet and workbook which puts the data in B12:15.

Depending on the date b1 and the person specified b2, i want the data to then transfer over to the other sheets on the workbook.

ie if gemma J did 25 pnc on 23-11-10, then i want it to take this over to the sheet gemma j and find the pnc box and input the figure for that date, in this case, b24.

I then want whenever the next person clicks on a particular persons tab, that it immediately shows the last piece of data entered.


I think this is quite easily possible, but am having problems with it. So if anybody could help i would be very appreciative.


Kind regards

Joe