title: How to get the cell references to update automatically for indirect() function in Excel?
body: <p>I am looking to pull data from a different workbooks and have found an excellent workaround in the indirect() function.</p>
  <p><code>=INDIRECT(&quot;'[&quot;&amp;$S$14&amp;&quot;]&quot;&amp;$T$14&amp;&quot;'!&quot;&amp;&quot;A8&quot;)</code></p>
  <p>My challenge is that I want this to apply to a few thousand cells with only bit(A8) changing. However, when I do ctrl+d it simply repeats the exact code for every cell.</p>
  <p>I want to make sure A8 is just a text value and not a reference to the value IN cell A8 because otherwise I need thousands and thousands of cells with just their name in them. However, making it INTO a text value renders it immune to ctrl+d.</p>
  <p>To clarify, I would like each consecutive cell to change to A9,A10,A11 etc</p>
  <p>How can I get around this limitation?</p>
  <p>Thank you</p>