Linked sheets auto-change in multiple languages

[JohanHbel]

I have very good experiences with posting my excell issues here on the forum in stead of looking for it myself for several days or weeks, so here it goes (please don't mind my spelling errors, i'm not native english):

I deliver reports to clients in two languages (dutch and french) because Belgium might be small, but it's definately not the simplest country . The report is always the same for every customer, except for the values which auto-populate (my template looks for values in other excel workbooks). When I change a formula in one of the two templates (the dutch one for example) I have to go to the other one and change it in that template as well. Problem is that not all my colleagues do that so sometimes we come up with different templates for the two languages..

my question: Is there a way to 'link' those two templates so that if I change something in one template, the matching cell in the other template automatically gets a color or a comment or something? That way everybody can see what changes have been made to the templates and we can adapt them.

Aditionally, is there a way to track differences between the two templates? (not all differences, only differences in formulas)

Thanks alot in advance!