Excel VBA - Compare Two worksheets and display the similarities in the 3rd sheet

Dear all,

I have 2 Two worksheets which I need to compare and I would like to display the similarities in the 3rd sheet.

Sheet1 has the following data:-

No.	Name
1	Federrer
3	Nadal
4	Djokovic

Sheet2 has the following data:-

No.	Name
1	Federrer
2	Murray
3	Nadal

Sheet 3 should have:-

No.	Name
1	Federrer
3	Nadal

Kindly keep in mind that rows of data in either sheets can vary from time to time.

Many thanks,
Vinod Krishna