Combining 5 workbooks into one and removing duplicates [Closed]

Report
-
Hello,
I have 5 address books saved onto separate spreadsheets and I would like to put them all together to make a master Address book. I would need to find any duplicates and remove them to a separate sheet to remove them from each address book so they essentially all match in the end.
Where do I start?
Just learning Excel so please Dumb it down for me!
Thanks
1ExcelLearner!


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!