title: Formula to grab value from a cell and use that to refer to a cell in another spreadsheet?
body: <p>I need help creating a formula in a cell in a spreadsheet that would allow me to grab a value from another cell and use that value to refer to yet another cell in another sheet.  </p>
  
  <p>For example, in a cell that returns a student's class grade (a progress report sheet) I have the cell refer to my master grade sheet (eg. the progress report sheet's cell would be:   <code>=mastersheet!E[grab value in cell A1 of current sheet])</code>  </p>
  
  <p>What formula do I use to grab a cell's value and use it to define/refer to another cell? </p>