Automatic Update of Each Tabs in a Excel

Hi

I have a record of 10 employees which include their DOJ, Salary, Bonus, Leaves taken and so on. Every month I receive this file in the same format. Now my Requirement is I need to create a master file , in which the first tab will be consolidated report i.e copying every month detail back to back.Rest of the tabs will contain each employee details. Every month when i update the consolidated tab, automatically employee tabs should also get updated

Thanks in advance
Shedar

Have You tried to update the "Consolidated Report" and use the VLOOKUP on the employee Sheets to update from the "Consolidated Report".

Regards...Cl.Klink

Thanks Cl.Klink for your response

I am not clear about your solution. Please correct me if I am wrong

Do you mean to say each time I have to do a VLOOK UP and that too by using vlook up how can i update the respective employee tabs


Regards
Shedar