I am trying to find a script and/or macro that can
compare data of two columns in two different worksheets:
A and B. Also put corresponding data of Column A from
worksheet A to the column A of Worksheet B. Mentioned
below is a sample:

Worksheet A:
Column A Column B
1 Apple
2 Orange
3 Mango
6 Pear

Worksheet B:
Column A Column B
Apple
Mango
Orange
Mango
Apple
Strawbery
Orange
Apple
Kiwi
Pear

I want to compare values of column B of Worksheet A with
the Column B of Worksheet B. (Please note that there is
one-to-many relationship between Worksheets A to B)
Where there is a match, I want to put a corresponding
value from the column A of Workseet A into the column A
of worksheet B. So after the comparison, the worksheet B
should look like this.

Worksheet B
Column A Column B
1 Apple
3 Mango
2 Orange
3 Mango
1 Apple
Strawbery
2 Orange
1 Apple
Kiwi
6 Pear

Can anyone help me please providing me any script and/or
macro that can do this?