Make Google Sheets Script Work on Multiple Tabs – Google Apps Script

The name of the current sheet is obtained by sheet.getSheetName(). You want to make sure that this name is one of "Sheet 2", "Sheet 3", "Sheet 4". A concise way to express this condition is to have an array sheetList with the names that need to be sorted, and check whether the name of the active sheet is on the list. The method indexOf does this check: it returns -1 if the name is not on the list.

function onEdit(event) {
  var sheetList = ["Sheet 2", "Sheet 3", "Sheet 4"];
  var sheet = event.source.getActiveSheet();
  if (sheetList.indexOf(sheet.getSheetName()) != -1) {
    var editedCell = sheet.getActiveCell();
    var columnToSortBy = 3;   
    var tableRange = "A2:T99";      
    if (editedCell.getColumn() == columnToSortBy) {   
      var range = sheet.getRange(tableRange);
      range.sort( { column : columnToSortBy, ascending: true } );
    }
  }
}

An easy way to do that would be to save the tabs that you want to run the script on in an array and then use a for loop to cycle through that array and run the code on each specified tab.

It would look something like this:

function saveRange(){
    var tabs = [
        'Sample_tab_1',
        'Sample_tab_2',
        'Sample_tab_3',
        'Sample_tab_4'
    ];

    var ss=SpreadsheetApp.getActiveSpreadsheet();
    for (var i = 0; i < tabs.length; i++) {
        var sheet=ss.getSheetByName(tabs[i]);
        var range=sheet.getRange('A8:AE47').getValues();

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