I'm trying to perform this function - can anyone tell me if it is at all
possible?

If the contents (text not numerical) of A1 in Sheet2 are equal to the
contents of A1 in the Sheet1 (current) then copy the contents of B1 from
Sheet2 to B1 in the current sheet (Sheet1).

If they are not the same progress down the A column (Sheet1) until they
match - eg. A1 of Sheet2 matches A11 of Sheet 1, then copy from B1 Sheet2 to
B11 of Sheet1; go onto A2 of Sheet2.

Note: The A column of Sheet1 has all possible matches from A column of Sheet2

Regards,

Tom