Google sheet and appscript expert

Hi, I need to someone who can do below: Trigger 1 if week = 2 (Week number is on CellQ4) 1. Looks through T3:T53 for the sheet name 2. VLOOKUP(U3 to U53,Indirect(CONCAT($T$4:$T$53,"!$A$2:$K$129") 3. Changes the value of what was Vlookuped to the value on W3:W53 to the Sheet indicated on T108:T157 if week = 1 (Week number is on CellQ4) 1. Looks through AB3:AB53 for the sheet name 2. VLOOKUP(AC3 to AC53,Indirect(CONCAT($AB$4:$AB$53,"!$A$2:$K$129") 3. Changes the value of what was Vlookuped to the value on AE3:AE53 to the Sheet indicated on AB108:AB157 Trigger 2 if week = 2 (Week number is on CellQ4) 1. Looks through T108:T157 for the sheet name 2. VLOOKUP(U108 to U157,Indirect(CONCAT($T$108:$T$157,"!$A$132:$K$228") *If Y108Y157 is not equal to Zero 3. Changes the value of what was Vlookuped to the value on W108:W157 to the Sheet indicated on T108:T157 *If Y108:Y157 =Zero 3 Copies Value of U108:U157 to A229:A248 and X108:X157 to I229:I248 of the Sheet indicated on T108:T157 Checks value of V108:V157 4.1 If V108:V157 = "PO Hse" copy value in W108:W157 to D229:D248 of the sheet indicated on T108:T157 4.1 If V108:V157 = "PO Crt" copy value in W108:W157 to E229:E248 of the sheet indicated on T108:T157 4.1 If V108:V157 = "PO Left" copy value in W108:W157 to G229:G248 of the sheet indicated on T108:T157 4.1 If V108:V157 = "PO in" copy value in W108:W157 to K229:K248 of the sheet indicated on T108:T157 if week = 1 (Week number is on CellQ4) 1. Looks through AB108:AB157 for the sheet name 2. VLOOKUP(AC108 to AC157,Indirect(CONCAT($AB$108:$AB$157,"!$A$132:$K$228") *If AG108:AG157 is not equal to Zero 3. Changes the value of what was Vlookuped to the value on AE108:AE157 to the Sheet indicated on AB108:AB157 *If AG108:AG157 =Zero 3 Copies Value of AC108:AC157 to A229:A248 and AF108:AF157 to I229:I248 of the Sheet indicated on AB108:AB157 * Checks for the next empty row so that past data will not be deleted Checks value of AD108:AD157 4.1 If AD108:AD157 = "PO Hse" copy value in AE108:AE157 to D229:D248 of the sheet indicated on AB108:AB157 (Same row with step 3) 4.1 If AD108:AD157 = "PO Crt" copy value in AE108:AE157 to E229:E248 of the sheet indicated on AB108:AB157 (Same row with step 3) 4.1 If AD108:AD157 = "PO Left" copy value in AE108:AE157 to G229:G248 of the sheet indicated on AB108:AB157 (Same row with step 3) 4.1 If AD108:AD157 = "PO in" copy value in AE108:AE157 to K229:K248 of the sheet indicated on AB108:AB157 (Same row with step 3) If you think you can make a script for that, contact me.