indirect....scan through workbook and find name

i have included a sample workbook; not that it may help as the file is located on our serve, but maybe im not saying it correctly?

also, i have highlighted in red what im looking to achieve, w/o having to go in all 33 workbooks. thxs for your time again!

i even tried this, maybe you can have some of your thought to this formula:

=INDEX("'J:\Sales Analyst\SWAT\Archieve 2011\"&I8&"\["&D9&".xls]"&E9&"'!"&E4&"",I4,I5,1)