Vacation Schedule

Here you go budy,
I have to creat a Vaction Schedule Workbook, suppose in june, my colleage JOHN will put In his respective sheet , the day he is taking a vacation day, suppose 1st June, in that cell he will Put "V" for 1 vacation day, this entry will be recorded in the Month's Total Sheet as a Number in John's Column, and then keep adding on if he takes another vacation day on 6th June.
same thing with "S" for Sickday, but in John's Sick Column Automatically , as "S" links to Column "S" in total sheet.
One Workbook
thanks