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