Dear All,

I have master sheet and other sheets of personnel of company. In their respective sheets, they add the information of the work carried out by them in last one month.

The information is like "Employee ID, "Name of Personnel" , "Location", "Position", "Name of project"............etc in respective columns.

Every sheet has their personnel id as the name of sheets. I want to update the master sheet from the all personnel sheets. Users can add new data or update the existing data. I can see codes for copying the data into master sheet but I want the code to

1) First add data from personnel sheets to master sheet
2) Update the already existing data
3) If new line has been added into personnel sheet then new line should be added for that person in the master sheet.

Please help.

Kind Regards,
Excel_126