For example: I have a folder name called TEST. And TEST contain aaa.xlsx, bbb.xlsx, ccc.xlsx,.......,zzz.xlsx 
Now if i enter a file name(aaa.xlsx) in a cell and enter vba button it should display data from aaa.xlsx.

-Folder Name and file names are static.