Google Sheet Script

volunteerSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Volunteer Signups');
  scheduledRacesSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Scheduled Races');

  //A from scheduled Races B
  var volunteerStartingIndex = 10;
  var scheduledStartingIndex = 2;

  for (var i = 0; i < 500; i++) {
    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 1);
    targetRange.setFormula("=INDIRECT(\"'Scheduled Races'!$B" + scheduledStartingIndex + "\")");

    volunteerStartingIndex++;
    scheduledStartingIndex++;
  }

  volunteerStartingIndex = 10;
  scheduledStartingIndex = 0;

  //B
  for (var i = 0; i < 500; i++) {

    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 2);
    targetRange.setFormula("=IF(A" + volunteerStartingIndex + "=\"\",\"\",TEXT(A" + volunteerStartingIndex + ",\"ddd\"))");

    volunteerStartingIndex++;
  }

  volunteerStartingIndex = 10;
  scheduledStartingIndex = 2;

  //C from scheduled Races B
  for (var i = 0; i < 500; i++) {
    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 3);
    targetRange.setFormula("=INDIRECT(\"'Scheduled Races'!$B" + scheduledStartingIndex + "\")");

    volunteerStartingIndex++;
    scheduledStartingIndex++;
  }

  volunteerStartingIndex = 10;
  scheduledStartingIndex = 2;

  //D
  for (var i = 0; i < 500; i++) {

    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 4);
    targetRange.setFormula("=IF(C" + volunteerStartingIndex + "=\"\",\"\",C" + volunteerStartingIndex + "+'Timezone Calc'!$A$2)");

    volunteerStartingIndex++;
  }

  volunteerStartingIndex = 10;
  scheduledStartingIndex = 2;

  //E
  for (var i = 0; i < 500; i++) {

    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 5);
    targetRange.setFormula("=IF(C" + volunteerStartingIndex + "=\"\",\"\",C" + volunteerStartingIndex + "+'Timezone Calc'!$A$3)");

    volunteerStartingIndex++;
  }

  volunteerStartingIndex = 10;
  scheduledStartingIndex = 2;

  //F from scheduled Races C
  for (var i = 0; i < 500; i++) {
    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 6);
    targetRange.setFormula("=INDIRECT(\"'Scheduled Races'!$C" + scheduledStartingIndex + "\")");

    volunteerStartingIndex++;
    scheduledStartingIndex++;
  }

  volunteerStartingIndex = 10;
  scheduledStartingIndex = 2;

  //G from scheduled Races D
  for (var i = 0; i < 500; i++) {
    var targetRange = volunteerSheet.getRange(volunteerStartingIndex, 7);
    targetRange.setFormula("=INDIRECT(\"'Scheduled Races'!$D" + scheduledStartingIndex + "\")");

    volunteerStartingIndex++;
    scheduledStartingIndex++;
  }