Filename changes daily, anyway to link to most recent file
 

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?