How can I catch updating / changing cells in a Google spreadsheet?

Question

Python

How can I catch updating / changing cells in a Google spreadsheet using python?
There are 3 tables (please do not confuse not 3 sheets, namely 3 different tables) with orders (the table structure is the same), you need to take from these 3 tables only orders with the "New" status. And bring them into 1 pivot table (So that the data from the table where the data came from and the pivot table would have two-way synchronization). That is, if I change the status of the order to "Completed" or "Waiting for goods" in the pivot table. The status has changed in the table where I got this data from.

Answer 1

Not rocketscience, but you will have to do something yourself.
Making assumptions from a picture is especially difficult. But suppose:
But these are all recommendations, and usually people will create a trigger on the EDIT event and try to make changes to other Tables.