Hello everybody,

the company I'm working for made a machinery configurator in several different languages (German, English, Italian, French... and many other) and I would like to know whether something like this is possible:

By clicking on a button some cells have to change their formulas so that the text in German is going to be automatically swapped by a text in English. By clicking on another button, the text swaps automatically to another language (I need 6 buttons in total).
I was thinking something like this: writing the various texts in a sheet (or several sheets, one per language maybe), by clicking on a certain button, the formula in certain cells should automatically change, showing me the selected language cells on the second sheet.
Moreover, I would like these cells to be blocked in order my clients using this configurator without messing up with it (this is a point of secondary importance, if it's possible to do it better, otherwise I will keep on sending them offers as a pdf.

Can anybody help me with this? I really have no clue how to make excel do this.

Thank you.