How do I get the last row of multiple sheets and put them together into a new row in an Excel VBA or Google Apps Script?

var OUTPUT_SHEET_NAME="For Output"
function myFunction() {
  vars = SpreadsheetApp.openById(SpreadsheetApp.getActiveSpreadsheet().getId());

  var sheets=ss.getSheets();
  var outputSheet=ss.getSheetByName(OUTPUT_SHEET_NAME);

  for(i=0;i<sheets.length;i++){
    varsheet=sheets[i];
    variable=sheet.getName();
    if(title===OUTPUT_SHEET_NAME){
      continue;
    }
//    Logger.log(title);
    var lastRowNumber=sheet.getLastRow();
    var lastColumnNumber=sheet.getLastColumn();

    // Obtain number of volumes
    // 3 is the third row, 1 is the first row, lastRowNumber-2 is the last row minus two rows of the header, and 1 is the first row.
    var numbers = sheet.getRange(3,1, lastRowNumber-2,1).getValues();
//    Logger.log(number);

    // Acquire inventory
    var values = sheet.getRange(3, lastColumnNumber, lastRowNumber-2,1).getValues();
//    Logger.log(values);

    // Create output values (Title, Volume, Inventory)
    var result = [ ]
    for(j=0;j<number.length;j++){
      result.push([title, numbers[j][0], values[j][0]]);
    }
//    Logger.log(result);

    // Output to Output Sheet
    var outputSheetLastRowNumber=outputSheet.getLastRow();
    var outputRange=outputSheet.getRange(outputSheetLastRowNumber+1,1,result.length,3);
    outputRange.setValues(result);
  }
}