Excel 2007 : Generating Automated Timesheet

There are four sheets in my workbook Timesheet, Attend, Leave, Holiday. Here are the abbreviations I want to put in my timesheet relevant for each employee code with the corresponding dates on the top as given on timesheet.

Conditions:
1. If the day exist in holiday sheet then it should be marked as “H” against all employee code in the corresponding column
2. Then is the employee has taken leave as given in Leave sheet then on the day column relevant it should be marked “L”
3. Again if the employees not taken leave and in Attend sheet -> Absent Column contain “TRUE” then it should be marked as “A”
4. Again if the employee not taken leave and in Attend Sheet ->Exception Column contain “TOUR” then it should be marked as “T”

P > Present
H > Holiday / Weekly Off
L > Leave
T > On Duty / Tour
A > Absent means unregularised absence

Please provide me email id so that I can forward you the excel sheet

Please help me in making this sheet automate.
Thanks for your kind help.
Shiven