VBA Excel to Analyse data in List Files

I want to compile same or similar data collected from all the files in a directory of List Files (Text Files that have a standard format like the attached example)
Using a Pivot Table or something like it to see how many and what files share identified attributes (highlighted in green in the example file).