VBA macro to match information from one column with another and delete rows no match

Hi,

I have tested different macro setups I found on different threads. Even if tried taking some parts and make some changes the macro didn't do what I wanted.

I need a macro because this setup will need to done on 20-45 workbooks containing information in 6-7 sheets from different reports containing anything from 300 rows to 30000 rows.

What I need help with is the following:

I will copy some information to Sheet1. In column A employer ID found. Let's say it's 500 rows.
In Sheet2 I will copy other information where column B contains employer ID as well.

I want the macro to look through Sheet2 column B and delete any row in Sheet1 that doesn't match in column A.

I can easily do this manually with a formula to create a True/False and then delete manually but this needs to be done automatically to save me hours of work.

Any suggestions?

Thanks in advance

Regards
//René