Automatic find difference between two data

[Kuannygohcheetatt]

Hey guys, my supervisor ask me to do one thing, he want me create a template where he only need to copy paste the first series of data in sheet 1 ,the second series of data in sheet two and when he click sheet three, it will display all data that are similar between sheet 1 and 2 and when he click sheet 4 it will display all data that are different. Any idea how to do it? I tried v look up but fail.



Sheet 1 data 1,2,3,4,5
Sheet 2 data 1,2,3,4,5,6,7
Sheet3 data 1,2,3,4,5
Sheet 4 data 6,7


Or another example
Sheet 1 cat, hat, dog
Sheet two cat ,pork, tom
Sheet three cat
Sheet 4 hat dog pork tom