I have a similar issue as this thread and I was hoping someone might be able to lend some assistance.
http://www.excelforum.com/excel-prog...worksheet.html
I am trying to create a summary sheet that looks at the name of each tab. As someone types in the name of the tab, the corresponding cell on my summary page will update to reflect the name.
(ie. A1=tab1, B1=tab2....)
Bookmarks