title: INDIRECT with increasing cell reference A1 A2 A3 etc
body: <p>may i know how to enable 
  (CELL A1 in SHEET1) </p>
  
  <p><code>=INDIRECT('SHEET2.A1')</code> </p>
  
  <p>to drag through columns and rows accordingly without having to type it out one by one</p>