I have an excel sheet with more than 45 work sheets in it. Each worksheet has around 200 names, phone nos & addresses.

Everyday I find more people and add a new worksheet to the same excel (I add them date wise).

Now my biggest problem is that I need to check that the names, phone nos & addresses I have taken out today are not present in the other 45 worksheets.

I can remove the duplicates from the same worksheet, but How do I check and remove the today's from the other 45 worksheets so there are no duplicates.

I can manually check each and every data that I add today, but it takes too much time as there are more than 200 entries daily. I would like to use a filter or some automated method.

Please help!