Macro to find and copy cells

Hello,
I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells that have the same information and copies it to another sheet? ex: if the part 14-604L is using in another site other than site 1 i would like that to be copied to another sheet so i end up with a list of all the shared parts among sites.

Thank you and sorry for such a basic question but I am not sure how else to find out, I have been reading but with no guidance i have a hard time visualizing it.

AB

site 1 site 2 site 3 site 4 site 5
14-604L 1 .44NRSR01.50 #150 hose
386-054 1.5 95 008 052.145
556-111 22.0318 111.094 009 055.0804
641-005 027.735 000157 10.4861 66
697-045 0096 000160 10.4881 066.6001