When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet.

if you have access to the source file, you can link a table or graph in Excel to your PowerPoint slide. If the data in the worksheet is changed, it is automatically updated.

Microsoft Excel can't map nonadjacent cells from the source spreadsheet to nonadjacent cells in a destination worksheet, however. While it has no problem linking groups of cells, nonadjacent cells ...

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Yes, it is possible to link the contents of a text box in Excel to data in a cell.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.