CODE EXAMPLE FOR JAVASCRIPT

Get Multipal Tab Value to One App Script

function saveRange(){
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sheet=ss.getSheetByName('Sample_tab_1');
  var range=sheet.getRange('A8:AE47').getValues();

  sheet.getRange(sheet.getLastRow()+1, 1, range.length, range[0].length).setValues(range);  
}