Clif McIrvin expressed precisely :
jic this discussion is of interest to anyone else .. or some future search
...

What I did in my case was loop through every sheet of every workbook in the
current folder (mix design worksheets) and build a summary worksheet, then
put that summary data into an auto-filter table. I used the double-click
event to activate the sheet behind the selected row in the table.

This would (imo) be a better fit for Access, but it does what it needs to.

Sounds similar to what I use an 'Index' sheet for, except it has
hyperlinks to the target sheets. If the sheet is in another wkb Excel
opens/activates that. No VBA used here!

I did fail to mention, though, that my sheet manager utility previously
mentioned also will activate (via the list's doubleclick event) any
selected sheet in the list, opening its wkb if need be. This is all VBA
here!<g What makes this work is the utility has the ability for the
user to show all app sheets and displays where (which file) they're
stored. This requires using stiff wkb/wks protection so moving/copying
sheets is tightly controlled, but not much of a problem since it
affords keeping a log of which sheets are stored in which wkbs AND
where those wkbs are stored. (If it's been moved elsewhere, users are
prompted to locate it) -Some clients are really demanding, huh!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc