What type of construct do I use to achieve the following? :

Sheet1(A:A) contains an expandable list of INVALID NAMES
Sheet1(B:B) contains a list of CORRECTED NAMES

I want to write VBA code that will SELECT Sheet2 Range(A1:H72),
and check data in each cell for entries found in Sheet1(A:A),
and replace each occurrence with data in Sheet1(B:B).

Do I use a FOR EACH-NEXT, IF-THEN, SELECT CASE...or some other construct?

And, how would such a Sub Routine be written...???