Hi

I am working on a spreadsheet with information on different items on
separate tabs. The first tab is a summary sheet where information from the
tabs will be entered onto a table.

I am trying to link the names of the tabs to a column on the summary tab. I
have tried using ='click on tab' . This works with inserting a value so that
the name of the tab appears, but then as it is just a value I connot
manipulate it in any way, eg - if I change the name of the tab it does not
change on the summary sheet!

This means I will have to potentially enter the names of hundreds of tabs
manually :-( any help would be greatly appreciated.