Loop Through Files in a folder

Hello All,   I have built a code to loop through multiple files in a folder and then try to consolidate in one sheet. I am able to accomplish but i am failing when ever my source file have only on...