How to copy a sheet to other spreadsheets and move it to the first (left) position
<p>I am using a script I found to copy the active sheet to all the other spreadsheets in a folder. It works fine, but I would actually like to have <strong>that copied sheet</strong> be set as the first (left-most) sheet in those other spreadsheets.</p>

<p>I know about "moveActiveSheet" but I can't seem to get it to work correctly (I'm still new to scripting.). The usage examples I have seen seem be for the current spreadsheet. Any help would be appreciated.</p>

<p>Current script:</p>

<pre><code>function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var pasteSheet = [ {name: "Paste Sheet", functionName: "copySheet"}];
  ss.addMenu("Copy to Spreadsheets", pasteSheet);
}

function copySheet() {
  var source = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = source.getSheets()[0];
  var sourceFile = DriveApp.getFileById(source.getId());
  var sourceFolder = sourceFile.getParents().next();
  var folderFiles = sourceFolder.getFiles();
  var thisFile; 

  while (folderFiles.hasNext()) {
    thisFile = folderFiles.next();
    if (thisFile.getName() !== sourceFile.getName()){
      var currentSS = SpreadsheetApp.openById(thisFile.getId());
      sheet.copyTo(currentSS);
      currentSS.getSheets()[currentSS.getSheets().length-1].setName('THIS WAS COPIED');
    }    
  };    
}
</code></pre>