Is there a way to look in a folder and if a file has a certain string
in it's name "Sep2006", it will open. I don't care what else it has in
the file name, but if that string is in there, I want it to open.

Basically, I'm going to have a sheet for say 10 people with their name
and Sep2006 in a folder. I want to then open 1 sheet at a time, take a
value from it, and aggregate it into a new sheet.

Thanks,
Brett