CODE EXAMPLE FOR JAVASCRIPT

copy multi cell value from one sheet to another using google app script

function multiCellCopy(){
  const ss= SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Order');
  
  const sRangeValues= ss.getRange(1,1,13,3).getValues()
  
  Logger.log(sRangeValues)

  let ss2=SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Copy');

  ss2.getRange(1,1,13,3).setValues(sRangeValues)


}