i have a folder with 23 workbooks, in each one there are anywhere for 1 to 50
pages, each page is a persons name and itemized expenses with a running
total, the name will appear in several of the workbooks, i also have a
workbook that you can look at to see each name and how much they have in each
of the different books without having to open one of the 23 books. what i
need to do is make a hyperlink or somthing else if there is a better way, to
click on a name and it will open more that one workbook if the name appears
in more than one. is this possible.