Google tables. Synchronization of one cell in different sheets, is it possible?

Question

Google

Tell me, please, is it possible to set up a cell in such a way that by changing it in, for example, "Sheet1", cell "A1" changes into "Sheet2" and vice versa - when changing cell "A1" into "Sheet2", it also changes into " Sheet1"?

On a practical example: on sheet 1 we have a database filled with managers. On Sheet 2, through a query, a schedule for the receipt of goods with the dates indicated in Sheet 1 is displayed. Is it possible to set it all up so that you can change the date directly in Sheet 2 (where the schedule is through query) and that this date is put down in Sheet 1.

Answer 1

yes, with scripts