Version: Microsoft Office Excel 2003

How can I repeat a sheet's tab name in a cell?

I have a summary sheet which has data fed from multiple other supporting
sheets. The supporting sheets are updated by other users and they modify the
tab name so it reflects their specific subproject effort.

Just as the summary sheet reflects the supporting sheet data, it would be
very helpful to state the tab name so it is clear what the data is
representing (i.e.- the subproject sheet name). I wish to create a link so
if the subproject (tab) name is changed, the summary sheet is automatically
updated.

I had hoped this would be similar to adding the file name and path in a
cell: =cell("filename") however, it is not.