How to link to another tab or cell in the spreadsheet? This feature can be use locally, for example linking a cell to another one. Repeat step 1 and 2. From here use the Place in this document option.

Click the Lists sheet tab or the tab that contains your list items. Select the list (A1:A4). Click OK, which will return you to the new sheet, where you’ll find a populated list in E4 ( Figure A ).

To activate all the links, write a macro that runs the links from each cell in turn. Click the Developer ribbon. Click "Macros" from the ribbon's "Code" tab to open Excel's Visual Basic editor.