ChrisO'Brien
New Member
- Joined
- Jan 23, 2013
- Messages
- 13
Hi,
I have a workbook setup that is basically a summary page for loads of pages within a workbook and their values. The pages are referenced as normal i.e Sheet1, Sheet2 etc.
What I want to do is list the tabs on a summary page and have the list self update when the tab names are changed. Is this possible? I have seen other posts similar but they only seem to be able to make a cell look for the name of the tab its on and not display on from another page
I hope that made sense
I have a workbook setup that is basically a summary page for loads of pages within a workbook and their values. The pages are referenced as normal i.e Sheet1, Sheet2 etc.
What I want to do is list the tabs on a summary page and have the list self update when the tab names are changed. Is this possible? I have seen other posts similar but they only seem to be able to make a cell look for the name of the tab its on and not display on from another page
I hope that made sense