Searching through a directory using a partial filename

Hello!

I am in need of help. I am trying to automate a very manual task in which I scour a bunch of excel files to copy and paste some info. So, our work orders (WO) are all created off a premade template. so the information I need is always in the same place on every file. I need a formula/program that can search a directory for a PARTIAL filename, and get info from a particular cell.

I say partial because the information I enter will be the beginning of the filename. For example: all our file names follow this format: (WO) (company) (State) (City).xls.

I want to type in SAL1234 (the WO) into Column A and have returned the value in $J$2 of the file 'SAL1234 RandomCorp TX Dallas.xls' in Column B for example.

I've spent this morning with NBVC trying to figure out a Formula funtion, but I get roadblocked by not having the full, accurate filename. And now I'm here

Oh and in case you're interested or need clarification, the other Thread I created is here: http://www.excelforum.com/excel-gene...cel-files.htmlgetting VBA help of which I've never used before.