Macro To Compare Multiple Excel sheets and highlight duplicates

I have multiple excel files which contain information about 1000's of products. I want to make sure none of the products are duplicated in all the files so I was looking into Macros but cant find one.

eg:

Workbook 1

Under "Name" column

iphone 5
ipad3
macbook pro

Workbook 2

Under "Name" column

samsung S2
Iphone 5
Samsung s3
macbook pro

Workbook 3

Under "Name" column

Samsung s3
Iphone 5
macbook pro


All I need is a macro that could highlight similar products (in the above example iphone 5, samsung s3, macbook pro) in different workbooks. Please help

Thanks in Advance

bummer!.. no reply as yet?

please guys help me out with this.. this is a dead end for me