title: Script to run on specific sheet
body: <p>I have a script that I have been using, but it only works with, as written, the active sheet (pulls a list of documents from the specified directory in Google Drive).  How can transform this to run on a specific sheet.  The name of the sheet is "Per 7".  </p>
  
  <pre><code>function list_all_files_inside_one_folder_without_subfolders(){
    var sh = SpreadsheetApp.getActiveSheet();
    var folder = DriveApp.getFolderById('0B4zzmqQYDRm2flZPRFVWd1FfSGpJTXFmcWlSLXVVTUZJRjNlU3QzTER6aHFsYVEzTDdrS00'); // I change the folder ID  here 
    var list = [];
    list.push(['Name']);
    var files = folder.getFiles();
    while (files.hasNext()){
      file = files.next();
      var row = []
      row.push(file.getName())
      list.push(row);
    }
     sh.getRange(1,1,list.length,list[0].length).setValues(list);
  }
  </code></pre>