Search cell contents in an entire workbook and return a specific cell from that sheet

Hello All,

First off, thank you in advance! This is my first post and I have been stumped trying to find a solution.

I am trying to create a formula to search a string of text specified in A3 (text is T1234-1234)and to search this string in another workbook on a specified line, but on all sheets until a match is found and to return another cell within the sheet being search. Below is a sample of what I am working with so far. Currently the formula is only able to search a specified sheet(4372666_A.TXT) in cell A6 and returns the value located in cell A7 only if A3 is located in cell A6 on the 4372666_A.TXT sheet. There will be roughly 100 sheets that need to be searched at a time.

IF(ISNUMBER(SEARCH(A3,'[EDICONFTESTEXCEL.xlsm]4372666_A.TXT'!$A$6)),LEFT(RIGHT('[EDICONFTESTEXCEL.xlsm]4372666_A.TXT'!$A$7,9),7),A3)

Please upload the workbook to explain your problem clearly

The workbooks have been attached. Thank you!