title: Excel - Pull data from a cell on a different sheet and hyperlink
body: <p>I know how to pull data from a separate worksheet in excel by using the formula <code>=Sheet2!A2</code>. That pulls whatever data I have in the A2 cell from my Sheet2. But is there away to pull the data from that cell and hyperlink it to the cell by using a formula? I know you can manually link it but I'm trying to make my sheet as automated as possible. Anything helps, thanks.</p>