find and replace data across different workbooks and sheets

I have a rather unusual problem to solve (let's not get into the how and why):

I need to find several IP adresses from workbook A (up to 37 columns of adresses) in workbook B across several sheets and replace the adresses in workbook A with the adjecent cell in workbook B's sheets.

For example, workbook A cell C3 contains 10.3.0.29 which coresponds to workbook B sheet 6 cell G31, now workbook A cell C3 needs to be filled with the new IP in workbook B sheet 6 cell G32 which contains 172.22.10.61

This is needed to build a communication matrix for a building automation system which we are migrating from an old network environment to a different one.

And lastly, I have no clue about VBA so be patient with me.

- Office 365 Desktop version
- not an absolute beginner but not quite intermediate