Name mapping - Excel

I have 2 worksheets.

1st worksheet contains the following:

Whilst the 2nd worksheet contains:

Column A in the 2nd worksheet contains the correct Account Names whilst columns B to E contains variants of the account names found in different reports.

What I want to do is to map the correct account names in Column A of the 2nd worksheet to column B in the 1st worksheet.

I'm unsure how I will be able to do this - will it be by multiple IF statements in going through Columns B to E or something along the lines of index / match?

Thanks in advance