title: Hyperlinking to sheets without using a script
body: <p>Important: I asked this question before and it was merged into another question where the solution is using a script. Such a solution, with a script, is not helpful to me, so please only offer a solution with formulas, thanks.</p>
  <p>I have a main sheet with a list of the names of the other sheets in the workbook. I want to create a glossary in the main sheet linking to cell A1 in each of the other sheets (a simple Hyperlink).
  In Col A - list of sheet names (e.g. Jan, Feb)
  In Col B - I want the hyperlinks (e.g. a link to Jan!A1, a link to Feb!A1)</p>
  <p>What I can do, is use INDIRECT and CONCATENATE to bring the respective value of the cells (I've added it in Col C in the example below), but I can't find how to create the links.</p>
  <p>Here's an example:
  <a href="https://docs.google.com/spreadsheets/d/1C1LghRPcutYBwgZZaitJQ1PVrgggr5XdvG6V7L32eE0/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1C1LghRPcutYBwgZZaitJQ1PVrgggr5XdvG6V7L32eE0/edit#gid=0</a></p>