Check for Duplicate data cell wise

Hi,

I have a Excel Sheet contains 3 sheets [Leads, Props & Agents]
I keep adding data in all Sheets time to time. Some times duplicates has been added.
I want to check the duplication every time after adding a data to any of these sheets.

For Example:-
If I Add data in sheet Props. I will run a Macro to check the duplicates with other 2 sheets.
If I Add data in sheet Leads. I will run a Macro to check the duplicates with other 2 sheets.

If duplicates found then I need duplicates summary as in sheet "Duplicates"
In Column A I want duplicate mobile number (If Duplicate found) and in Column B I want the sheet name which contains duplicate data.
In Column C I want duplicate Land line number (If Duplicate found) and in Column D I want the sheet name which contains duplicate data.
In Column E I want duplicate email id (If Duplicate found) and in Column F I want the sheet name which contains duplicate data.

SO every time I will add data and I will run macro.


Note: some cell contains Multiple numbers and email id separated by "/"
So Check all the number email individually