Udate Google sheet tab with data from other tab for records that match common key

We have a master spreadsheet where we track order status and payment. At the end of the month we receive from accounting a spread sheet with the orders that are paid or unpaid. There are two tabs: ORDER BOOK and PAYMENT STATUS There's a common ORDER NUMBER field in both tabs We need a script that when run by the user (add script to sheet menu) can update the relevant orders in the ORDER BOOK with the PAYMENT STATUS (there are 4 columns to be updated in ORDER BOOK for every record match) After the update is processed the file PAYMENT STATUS needs to have a column showing "MATCHED/UNMATCHED" for each record. Sometimes accounting makes a mistake and includes orders from other division, having the matched/unmatched field will allow us to identify the wrong ones. Sample data: [login to view URL] Common key: WO ID Columns from PAYMENT STATUS to be updated in ORDERS N to R (into AJ to AM)