title: How can I create one hyperlink to each worksheet in one index sheet?
body: <p><strong>Edit:</strong>
  After doing a bit more research I stumbled on this <a href="http://exceluser.com/blog/142/quickly-find-a-worksheet-in-an-excel-workbook-with-many-sheets.html" rel="nofollow">handy little shortcut</a>:
  Just right click on the little arrows on the bottom left corner to show all sheets - no code required!</p>
  
  <hr>
  
  <p>I have an excel workbook with 100 tabs. Luckily for me the tabs are all numbered 1-100. I Have an index page with all the numbers in a row and I would like to make a row next to that row with a hyperlink to the numbered tab. </p>
  
  <pre><code>   A        B
  ---------------------------
  |  1   | link to tab 1    |
  ---------------------------
  |  2   | link to tab 2    |
  ---------------------------
  </code></pre>
  
  <p>etc...</p>
  
  <p>So far the most promising thing I've found is: </p>
  
  <pre><code>=Hyperlink(“C:\Documents and Settings\Admin1\Desktop\” &amp; A1 &amp; “.xls”,A1)
  </code></pre>
  
  <p>I know that the hyperlink function expects:</p>
  
  <pre><code>=HYPERLINK(link_location,friendly_name)
  </code></pre>
  
  <p>And when I do it manually, I get this:</p>
  
  <pre><code>=HYPERLINK('1'!$A$1,A1)
  </code></pre>
  
  <p>So I want to do something like this:</p>
  
  <pre><code>=HYPERLINK('&amp; A1 &amp;'!$A$1,A1)   
  </code></pre>
  
  <p>But it's not working.  Any help is much appreciated. Also, if there is an easier way to approach this - I am all ears. </p>