MODTA

function myFunction() {
  const ss = SpreadsheetApp.getActive();
  const idSheet = ss.getSheetByName("MODTA Newbies Team Database");
  const writeSheet = ss.getSheetByName("MODTA Newbies DB");
  const sheetIds = idSheet.getRange("U4:U").getValues();
  const userIds = idSheet.getRange("A4:A").getValues();
  const numIds = sheetIds.length;

  for (let i = 0; i < numIds; i++) {
    const id = sheetIds[i][0];
    const user = userIds[i][0]
    if (id == "" || user == "") continue
    console.log(user, id)
    const tracker = SpreadsheetApp.openById(id);
    const trackerSheet = tracker.getSheetByName("Tracker");
    let values = trackerSheet.getDataRange().getValues()
    values = values.slice(8)
    values = values.filter(arr => { return !arr.every(n => { return n == "" }) })
    values = values.map(arr => { return arr.slice(0, 4) })
    values.unshift([id, user, "", ""])
    const range = writeSheet.getRange(1, i*5+1, values.length, values[0].length);
    range.setValues(values)
  }
}