Importing from a text file without opening

[SupertechLC]

Hi everyone.

I am currently working in a lab that requires me to write up a spreadsheet that will basically import data from a text file (delimited by tabs) without actually having excel open it (because of legal issues we cannot see ALL results, we only want to pull the ones we want). Basically, I surfed the web and this forum and am having a hard time pulling all the information together to come up with a good macro. I want to link a macro to a command button. For example, for one test called "X", the samples will be labeled such as 22-X529458-Y295195-Z235011, in which Y and Z are also tests linked to that sample. Id like the macro to search through the text and find all the numbers associated with test X (in this case just 529458), and list them in a column. In the file there will also be a result for test X, and in the next column for that sample, I want the result to import in as well. Basically I only want the number, and then next to it the result that says "X/X; Mutation Absent"

In the dummy file I uploaded it only has 1 sample, but there can be multiple, and with different tests like 87-X395190-Z235920, or 11-Y359383-Z359911, but will all be formatted with this nomenclature. Any help is VERY appreciated!! Thank you!!!