title: Reference values from a excel worksheet
body: <p>I have two worksheets. Say SheetA and SheetB</p>
  
  <p>The <strong>SheetB</strong> uses the cell values from <strong>SheetA</strong> to calculate and arrive at a value. There is quite a lot of cell referencing inside the <strong>SheetB</strong> to calculate and arrive at a result. This result then has to be displayed as an output on <strong>SheetA</strong>.</p>
  
  <ol>
  <li><strong>SheetB</strong> uses value from a cell in <strong>SheetA</strong></li>
  <li>Calculation is performed on <strong>SheetB</strong>, resulting an output</li>
  <li>Output is displayed on <strong>SheetA</strong></li>
  </ol>
  
  <p>Initially, I used just cell referencing to calculate the result and displaying it on the <strong>SheetA</strong>. However, there are multiple places in <strong>SheetA</strong> where the calculation has to be performed by sending the value to <strong>SheetB</strong> </p>
  
  <p>Excel experts any ideas on how to proceed on this?</p>
  
  <p>Is there a way I can make the entire worksheet as a function and keep calling the sheet passing the required parameters?</p>