title: Drop-down list of hyperlinks to different sheets in Excel
body: <p>I have 5 different sheets: S1, S2, S3, S4, S5. And an "Info" sheet where i have the overall information, where in every row I want a dropdown along with direct link to one of the sheets(S1, S2, S3, S4, S5). I tried using <strong>Indirect</strong> function along with <strong>Address</strong> but it is not dynamic. Is there a way of how to make a drop-down list with hyperlink to the sheet directly inbuilt with that?</p>
  
  <p>I hope i could describe my situation. </p>