Delete entire row based on criteria

Morning all,

I have attached an example worksheet. Sheets 1 and 2 show you how my data is now.

To explain, based on the name column ('B') I would like the code to delete the ENTIRE ROW when a person only features on either sheet 1 or 2 (but not both). For example, in the attached the person called 'Dave' would be deleted from Sheet 1 because he only features on Sheet 1 and not Sheet 2.

So if a person is present on both sheets then they are left alone. The spelling of each name will always be correct but the list of names may be in different orders (as they are in sheet 1 and 2 in the example).

Thanks