Is there a way to delete rows if they fit a condition?

For example:

Sheet 1 contains all the names.
Sheet 2 contains names I want to get rid of the whole row.
Sheet 3 what I want to end up with.

SHEET 1
A
B
C
D

SHEET 2
A
B

SHEET 3
C
D

Can anyone give me a step by step guide on how to do this please as I do not
know a lot on excel or visual basic.

Cheers