title: Reference Excel worksheets dynamically
body: <p>I have a problem that should be so simple, but I'm not getting my head around it. I do printed pricelists for a store and this year they've split up the part numbers into 5 worksheets instead of one. </p>
  
  <p>When a user wants to print out a pricetag, she enters the = into C10, clicks the Worksheet "Pricelist" and navigates to the part number she needs.</p>
  
  <p>The resulting formula for C10 is: <strong>=Pricelist!B40</strong></p>
  
  <p>E10 must contain more info about the part number so E10 formula is: <strong>=VLOOKUP(C10,Pricelist!B:N,2,FALSE)</strong></p>
  
  <p>However, now with the new worksheets she might select Worksheet "New_Items" in which case the resulting formula for C10 is: <strong>=New_Items!B40</strong></p>
  
  <p>How can I write the formula for E10 so that it references the same worksheet that C10 does.</p>
  
  <p>I need E10 <em>=VLOOKUP(C10,<strong>Pricelist</strong>!B:N,2,FALSE)</em></p>
  
  <p>to automatically become *=VLOOKUP(C10,<strong>New_Items</strong>!B:N,2,FALSE)*</p>
  
  <p>That make sense? Is that doable to have Excel modify a worksheet reference based on another cell's reference?</p>
  
  <p>TIA!</p>