All

I have a source file that changes names daily (date
included in name), is there anyway to look for the file
name but the pick up the lastest one created.

Either via vlookup or macro or Excel Query?