title: Auto Update specified tab in Google spreadsheet from Web via script
body: <p>I am currently trying to pull in data from a website into my Google Sheet, however, it will automatically pull the data on whatever tab I am on when the sheet updates.</p>
  
  <p>The script I currently have is below. I have 5 tabs in the workbook and the tab I need updated is labeled 'Update' and is the 3rd tab in the workbook. </p>
  
  <p>The data currently pulls in correctly, however, it will not only update the tab I need updated.</p>
  
  <pre><code>function getData() {
      var queryString = Math.random();
      var cellFunction = '=IMPORTHTML("http://www.golfchannel.com/tours/pga-tour/2017/us-open/?' + queryString + '","table",2)';
  
      SpreadsheetApp.getActiveSheet().getRange('A1').setValue(cellFunction);
  
  }
  </code></pre>