Find and replace value in all worksheets in another workbook

Hi, I am a newbie writing a macro and stuck on how to continue. Problem is I have some data in cells a1 to B10 in first worksheet of workbook "Test1.xls" . A represent the product and b the price. To create a macro vba in workbook "Test1.xls" that will loop through all worksheets in workbook"Test2.xls", compare cells A1 to A10 from "Test1.xls". If A1 matched with the cell, copy from "Test1.xls" cell B1 value to the matched cell adjacent cell. Then check A2 to A10 and repeat.

Sounds complicated. Thanks a million in advance

Here is the actual file Feb and Jan. To find all part number in Feb file, compare with Jan file all worksheets, and if match, copy all Feb Part value to Jan file all worksheets
Feb file
Part Value
36123 15
36145 16
3251 17
a1254 18
3214a 19
12345 20
14259 21


Jan file with different worksheets "A", "B", "C"

A contains
Part Value Part Value Part Value
36123 9 36145 10 3214a 11
a1254 9 3251 10 3214a 11
3214a 9 a1254 10 36145 11
36123 9 3214a 10 3251 11

B contains
Part Value Part Value Part Value
a1254 9 36145 10 3214a 11
36145 9 a1254 36145 11
3251 9 3214a 3251 11

C contains
Part Value Part Value Part Value
36145 9 3214a 10 3214a 11
3251 9 36145 10 a1254 11
3214a 9 3251 10 3214a 11


Note the part values can be found anywhere in the different worksheet