title: Use CONCATENATE to create a hyperlink to a cell in a different sheet
body: <p>I have a workbook with many sheets. I want to create sort of a glossary with direct links to the different sheets.
  In col A there is a list of the different sheet names (e.g. Jan, Feb, Mar).
  In col B I want direct links to cell A1 in the respective sheet (e.g. to Jan!A1, to Feb!A1 etc.</p>
  <p>I can bring the value of the destination cell (A1) using INDIRECT+CONCATENATE. for example, =INDIRECT(A2&amp;&quot;!A1&quot;) will bring the value of Jan!A1 (where cell A2 holds the sheet name: Jan).</p>
  <p>What I can't do is make it a link that when clicked will take me to Jan!A1</p>
  <p>To make things easier, I've added an example:
  <a href="https://docs.google.com/spreadsheets/d/1z_UuA62ghUejFwGWKpT_smMhKM4QAVMgZrKotim8WHE/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1z_UuA62ghUejFwGWKpT_smMhKM4QAVMgZrKotim8WHE/edit#gid=0</a>
  In the sheet &quot;Main&quot; Col A are sheet names. Col B is where I'd like to show the hyperlinks. Col C shows the values (it's of no importance, just since I referenced it in my question)</p>