Master file without repeating rows

Hi,
my director assigned me a task on excel and this is somewhere beyond my knowledge.
Here it is :
My Director needs that all his managers give him all their customer/supplier contact details in a standard format.There are several Managers and each of them submits him a copy each usually updated. However he wants to have a Master file having all the contacs compiles in one excel sheet.
Only issue is that some managers may have same customers/suppliers and he would like to have the master file cleaned without repititions.
Some columns may have same compnay name but contact details may differ and these data shall be kept. Data with similar rows shall be kept to only one.Only department to have Managers initials so as to know which customer/supplier are assigned to.
Can this be done?
And if not too much asked, can the master file data be fed from the managers idividual contact files?
Please se attachement for managers file format.

Hey, Not sure about the linking to the master file, I literally posted a very similar thread to this 5 minutes before you, so if I get a response on how to link them I'll keep you posted! But as for the duplicate rows theres an option in excel under the data tab, remove duplicates thats used for it

Is there any way to automate the duplication removal?