Pulling parts of data from multiple sources.

Hello,

I am attempting to compile a data set from thousands of file. Thankfully this will only need to be done once so I am not worried about the time it takes the script to run...

All of the files are in one location...

A sample of the data is attached the problem is its not in the best format to deal with its a tab delaminated file essentially I had to change the file format to get it to upload as its actually .$$$ but its the same as a tab delaminated which I am able to open with excel.

A sample of the expected output is also attached.

Basically I need the part number from A1 copied from the data file into the compiled list with pieces of the data which are in a long string in A13/14 which will look through all files in a folder. All of which have the same format.

If anyone can do this it would be amazing.