Script for Google Spreadsheet

I would like a script to copy the entire row of a document sheet into a sheet of another document when the first column puts a predefined value. When making further changes, I should copy my row again over the existing row. I have two different Google Spreadsheet tables. Table 1 and Table 2 In Table 1 I simulate product orders based on the information received by customers on the phone. If the order is concretized, in the first column choose the "approved" value and I would like to copy it in Table 2. I would like this copy to be done automatically, through a script, when I put the "approved" value. But when I subsequently modify the order in Table 1, it also changes automatically in Table 2. Also when I subsequently modify the order in Table 2, it also changes automatically in Table 1. When you start to fill cells from Table 1, I wish to automatically fill timestamp in column 2, with the date and time of starting filling, and when the first column I choose the "approved" value, I wish to automatically fill timestamp in column 2, with the date and time of choosing the "approved" value. The two timestamps do not change for later changes. When I choose "Approved" from the first column, I want to automatically fill in column 4, a "MS0000001" order number that grows from 1 in 1. Subsequent changes in Table 1 should be checked depending on the order number, if any, and if it exists, automatically copy the row back to Table 2. I mention that the lines to be copied are formulas and only their values ​​must be copied (withour format or formula). I mention that there are 4 different Table 1 that will be copied in a single Table 2. The order number will be different depending on the source table. I mention that the table will have thousands of rows and will have to be optimized to have a great workload and load speed and also to be pure code, not using third part apps.