Create link to a different workbook

[isassy16]

I have a master spreadsheet that tracks all kinds of different data from other workbooks. However, I try to link my master to one of them so when I click on a cell in my master, it opens up the other workbook that has a few tables in it with lots of data. My goal is to just have a cell with a link to get me to all that other data instead of just linking one cell value to another. I tried hyperlinks, copy and paste through links but it is not working. Any suggestions?

 

[GlennUK]

To get all the data from a different workbook sheet, try doing something with Power Query.