Summary Sheet Linking To Multiple Files

I am trying to create a summary sheet that automatically gets information from files in a folder.

Lets say I have two folders - Data and Summary. Data folder has many files. Files are added regularly. The files are named in systematic way in following format:
[Unit Number][Type][Job Number]

Exampleas of Unit Number: 75845, JBKU238547-6, T-546
Types: ae, hydro, noret, refurb
Examples of Job Number: 96789, 96780, 95847

The example of a filename will be like this: T-546refurb96780. Each file has a field called test date and up to 13 rows of information in tabular format.

Now, in my Summary file in folder Summary, I would like to automatically get values from all the files that are in the folder Data. If a file is added in the Data folder, the Summary file should automatically know that. The summary has to be sorted based on the test date.

I would like to assign 13 rows for each unit.