title: How to refer to another workbook/worksheet dynamically in excel
body: <p>Currently I am trying to link to another workbook/worksheet using dynamic range;
  i.e. using <code>ADDRESS(some function)</code> to get a range (eg. $A1:$C10)
  then linking it to another workbook.</p>
  <p>Eg. On Worksheet 1:
  <code>='Worksheet2'!INDIRECT(ADDRESS(function A):ADDRESS(function B))</code>
  but it returns error.</p>
  <p>Does anyone know how to work around this?</p>
  <p>I know using VBA is a simpler solution but my colleagues are unable to use VBA (I'm currently in finance) so I'm trying to make it as &quot;excel&quot; as possible</p>
  <p>Thank you in advance!</p>