Collect several sheets in one

[oshliaer]

function copyMultipleSpreadsheet2(){
  var sheets = [];
  
  sheets.push(SpreadsheetApp.openById('ssssQ').getSheetByName('Sheet1'));
  sheets.push(SpreadsheetApp.openById('sssso').getSheetByName('Sheet1'));
  
  var data = sheets.reduce(function(p, c){
    var values = c.getRange('A2:D').getValues().filter(function(row){
      return row[0]!=='';
    });
    p = p.concat(values);
    return p;
  }, []);
  
  SpreadsheetApp.getActive().getSheetByName('Sheet1').getRange(1, 1, data.length, data[0].length).setValues(data);
}
``

[oshliaer]

If you have a list of ids and sheets names on Sheet2 you gane generate sheets programmatic.

|       F       |    G    |
|:-------------:|:-------:|
| qwerqwerqwrwe | Sheet1  |
| asdfjkhasdkhf | Sheet1  |
| asdfasdfasdfj | Sheet10 |

var sheets = [];
// Getting a list of ids
sheets = SpreadsheetApp.getActive()
  .getRange('Sheet2!F:G')
  .getValues()
  .reduce(function(p, c) {
    if (c[0] !== '' && c[1] !== '')
      p.push(SpreadsheetApp.openById(c[0]).getSheetByName(c[1]));
    return p;
  }, []);