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