Google Sheets script for copying data between sheets.

data_copy.js

function copyValues(source_name,dest_name,range_name) {
   
   // Get Spreadsheets
    var key = "<YOUR_SPREADSHEET_KEY>";
    var source_sheet = SpreadsheetApp.openById(key).getSheetByName(source_name);
    var target_sheet = SpreadsheetApp.openById(key).getSheetByName(dest_name);

    var lastRow = source_sheet.getLastRow(); 

    // Set Ranges
    var source_range = source_sheet.getRange(range_name + lastRow);
    var target_range = target_sheet.getRange(range_name + lastRow);
    
    // Fetch values
    var values = source_range.getValues();
    
    //empty the target
    target_sheet.clearContents();
    
    // Save to target
    target_range.setValues(values);
    
}