Update cell values from unopened workbook using link containing a file name in cell

I am trying to populate a quote log based on one cell entry. The cell that would have the entry would be a file name such as 12345 (without directory, path, and file type).
Currently, my worksheet is set up so that column A would have my file name and the remaining columns contain information "collected" for specific cells in the file referenced by column A. Those items are things such as a date, customer name, etc...
I need this link to update whether the files are opened or not. Here is what I thought would be my link... ='\\myserver\myshare\TRI["A2"]&.xls&quote'!B5. This gives me a #ref. Please help.

The actual name of the file contains the TRI but only the numbers would be entered into the spreadsheet for a reference to the file name. I have a working hyperlink that takes me to the document using the cell entry. I just cannot get any values from the linked document like I want.

I need this becuase my supervisor is always creating quotes and does not want to take the time to enter all of the information in a log. If he enters the quote number at least, I am hoping to have the rest done automatically.

Thank you. Will I have to install this add-in on every computer using this workbook to get it to work properly? If I use this add-in, what would my formula read? I have never used and indirect formula before.

I am trying to link cells from one .xls to another .xls (log file) based on me entering the file (without type) name in column A and a date in column B. I was using the indirect.ext, but my workbook is getting slow with all of the updates it must complete. I would like to write a macro to do the same thing (upon saving the document) as my indirect.ext link but only update the cells in the rows I have modified during the current session (unless you think it can occur for 3000+ rows upon save without taking forever). I have a file with one row completed with the indirect.ext as an example and a text box stating what I am trying to do in the attached file. Every time I attempt a macro, I error out with a run time error or some other frustrating thing. Ideally, the macro would run only on the rows updated within the current users session and would provide "N/A" in all columns right of column B if a bad filename was entered. Each file the macro would pull information from could be a closed or open file. It would also be nice to have a save log on a second sheet to show which session each row was updated i and by whom.

Ok...I cannot seem to get this to work even on my computer without bring the other users into the mix. I just don't get it. I have a hyperlink to the file working just fine using the cell value, but cannot get this to work. Would it be easier to run a macro to accomplish this task?

Bump...No resolution as of yet...

I have more information that I can provide as well...

I am looking to have a macro that completes an update of 10 columns of a workbook on save with values from many other workbooks that are alike in format (same worksheet and cell reference for all referenced workbooks), but contain different information. The macro needs to only complete the update on the rows modified during the users session and containing a file name in column "A" due to the amount of files being referenced. The workbooks containing the related data are all in the same location on my computer and I am listing the file names (without path and file type) in column "A". I had an Indirect.ext fuction working originally, but ran into issues with the 2000 row workbook becoming very slow. Any help is appreciated. I can continue to use the Indirect.ext function that I am using, but am worried that the file will crash due to the amount of files it is collecting data from.