function myFunction() {
 var mastersheet=SpreadsheetApp.openById('XXXXX').getSheetByName('Master');
 var G1=SpreadsheetApp.openById('XXXXX').getSheetByName('G1Targets');
 var G2=SpreadsheetApp.openById('XXXXX').getSheetByName('G2Targets');
 var G3=SpreadsheetApp.openById('1ZmlLY4eHFS7eMsoqnyPPsmiW0EXth0KX7WJIWu-oiX8').getSheetByName('G3Targets');
 var G4=SpreadsheetApp.openById('XXXXX').getSheetByName('G4Targets');
 var counter=mastersheet.getLastRow();
 var lastColumn=mastersheet.getLastRow();
  var sheetName=mastersheet.getRange("A1:A").getValues();
  for (var i=1; i<=counter; i++)
  {
    var range=mastersheet.getRange(i,2,1,lastColumn)
    if(sheetName[i-1][0]=="G1"||sheetName[i-1][0]=="G2"||sheetName[i-1][0]=="G3"||sheetName[i-1][0]=="G4"){
    if(sheetName[i-1][0]=="G1")
       {
         var target=G1;
       }
    else if(sheetName[i-1][0]=="G2")
      {
         var target=G2;
       }
    else if(sheetName[i-1][0]=="G3")
      {
         var target=G3;
       }
     else if(sheetName[i-1][0]=="G4")
      {
         var target=G4;
       }
    var lastRow=target.getLastRow();
    range.moveTo(target.getRange(lastRow+1,1,1,lastColumn-1));
    }
  }
}