Is it possible in google docs to synchronize cells in different sheets?

Question

Google Sheets

Is it possible in google docs to synchronize cells in different sheets?
Let's say there are 5 sheets of google docs, how to synchronize cell A1 on them, so that when the value in cell A1 on any sheet changes, the value on all other sheets changes accordingly?

Answer 1

1. If in all other places you only need to look at these changed values, but do not change them manually, then it’s enough just to refer to the source with a formula, for example =A1, if the values ​​​​in the source do not consist of one cell, then the formulas can be complicated using constructions =queryor =filter.
2. If you need synchronization from all places in a table (or several tables), this can be done with a Google Apps Script script.
It will be easier to explain with a specific example, write to [email protected]