title: Automatically increment sheet reference when dragging formula
body: <p>I have a formula with the following syntax:  </p>
  
  <pre><code>=SheetName!E10  
  </code></pre>
  
  <p>and need some way to drag the formula and change just the sheet name as it moves to the right. So the <code>E10</code> part needs to stay the same with the sheet number incrementing as I drag the formula. We have many rows and columns to do and this would definitely speed us up.</p>
  
  <p>Is this possible? </p>
  
  <p>So the result would look like this:</p>
  
  <pre><code>=Sheet1!E10    =Sheet2!E10    =Sheet3!E10
  </code></pre>
  
  <p>This is the result:</p>
  
  <p><img src="https://i.stack.imgur.com/cjqwq.png" alt="SO26599056 question example">  </p>
  
  <p>from applying this formula:</p>
  
  <pre><code>=INDIRECT("mo"&amp;COLUMN()+0&amp;"!B4")  
  </code></pre>