to insert a master sheet with formulas which can verify other work sheets in it

dear friends

i have attached a file its a salary sheet (sample file) for three months, in this file i want to insert a master sheet where all the advance deductions are verified that they are properly deducted (highlighted the columns) . the person name will be verified with fathers name and they will keep on changing. First month will be compared with the next month, so please help me to create it as there are two type of advances old and new. I hope every thing is clear enough or let me know?.

Thanks in Advance

Manoj Sharma