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); }
Source: webapps.stackexchange.com