@Mayank_Soni
the solution given by @ashwin.ashok is a preferred one, as long as Sheet 2 has not to keep remaining Duplicates.
We do use here in the forum the copytodatatable for our suggestions. In case of empty filter results are to expect you can rewrite the query as described here:
ashokkarale
Yoichi
jawagarraja123
ppr
anjani_priya
Sayed_Tabrez2
devasaiprasad_K
MD_Farhan1
Parvathy
shashidhar.marihal