Hi Mike,
The directory structure is C:\???\???\PartNumber\SerialNumber\DateTested.
Originally I was thinking of selecting the directories in an explorer type window with a Ctrl+Click. But after reading your post it is becoming clear. Instead of clicking the mouse I can fill in an array of serial numbers which I can use to build a path with since I know where the part number folder is located. Which will give me the subfolders with the dates which is what I want. (attached picture) I think this would be the fastest search since I do not have to build a list of every serial number then pick out the ones I want.
But the rabbit hole is getting deeper. I will then need to check the directories I just dug up and make sure they have a valid test report so I know the data is good, then I can crunch my data files. That should not be hard though.
Thanks for the help