Synchronize formula changes in master sheet into individual sheets

Hello!

I have a problem with transferring changes in formulas from one sheet to identical other sheets, all in Google Spreadsheets instead of Excel.

There is a master sheet with calculations that each employee has their own copy of. So the employees only change data in their own file and their calculations have no cross references to the master file or other files. So far so good, but now when changes are made to formulas in the master file, they are copied manually to each individual file in tedious detail work - that must be easier!

In the first step I tried to store the formulas via IMPORTRANGE in the single files. Unfortunately, then the calculation does not react to data input in the single file, but transfers only changes in the master file. What I want to achieve is the exact opposite: The individual files are independent of each other and can be used by the master file for calculations, but if I adjust the formulas in the master file, they should be automatically transferred to all individual files. So I want to synchronize the stored formulas of the master file, not the values in the master file.

One possibility would be to build the formula in the single files in such a way that the calculation takes place there and refers to the inputs in the single files, the basic data of the calculation (e.g. the price per unit) is taken over from the master file via IMPORTRANGE. But this is very cumbersome and complicates the calculation formulas a lot. Unfortunately I have no idea about VBA or programming in general.

How can I solve my problem with the best possible input/output ratio?

Thanks in advance!

Google Sheets doesnt use VBA, however it can use javascript in "Apps Scripts".

perhaps you can consider synching data from the user sheets directly to the master sheet where all calculations are done.
its not cumbersome because if setup correctly the synch can be automatic and formula calculations are automatic in google sheets.