VBA script to substitute text from an excel sheet into various word docs by filepath

Hi,

I'd be grateful for some advice on the following VBA requirement I have, which I imagine has been created in one form or another but I've not been able to track it down.

The company I work for has a word doc template for an inspection report. The user has to edit each report and fill in the data about a property. It would be useful to edit the data in a centralised work sheet, and then have this placed in the respective word documents for each property using either a substitution approach. I don't think mail merge is feasible as the company template is very and formatted with corporate branding etc.

Is it possible to create a VBA that, when you tell it the filepath of a word document, can substitute a string for another desired string contained in the excel sheet?

I've attached a zip folder which contains what I am looking to achieve.

Thank you

Tom