It isn’t possible to link complete columns in different sheets. However, it is possible to link a range of cells in a column together. In fact, it is possible to link up to 500 cells in a column in one operation. The cells in that column will then automatically update whenever the cells in the original column are updated. To link selected multiple cells in a column, first create a Hyperlink in a cell as explained in the section “Create a Hyperlink to Another Sheet within a Cell” above.  The follow the steps for either option 1 or option 2. Note: There is a 5000 incoming links limit per sheet.