title: Indirect function in Excel - dragging down the column
body: <p>I'm working on a workbook that will have a master list of tasks for a group, and then each person within that group would have a worksheet with their specific information.  I'd like to make a few columns of information from those sub-worksheets populate back into the master list.</p>
  <p>I think what I want to do is an indirect reference to the worksheet tab names.  The following formula works for me:</p>
  <p>(B2 in this is a column that references the worksheet name, and E2 is the cell from that worksheet that i want returned)</p>
  <p><em>=INDIRECT(B2&amp;&quot;!E2&quot;)</em></p>
  <p>so, for example, B2 might say &quot;Sarah&quot;, in which case the formula returns the value from cell E2 on worksheet &quot;Sarah&quot;, which is exactly what I'm wanting to happen.</p>
  <p><strong>The problem I'm running into is that when I drag this formula down to the next row, my cell reference to E2 stays the same rather than progressing to E3 like I would like it to.</strong></p>
  <p>I have 3000 rows that I'd like to do this for, so manually re-typing the row # isn't sounding like fun.  Is there any way to make that automatically progress?</p>
  <p>I'm pretty sure my issues are in those &quot; marks, but I'm drawing a blank.  Can anyone help?</p>