Getting All Files From One Folder Through Batch Macro

[Franzil]

Greetings,

I have this batch macro that I'm always using to get multiple files and sheets with different schema however, upon using it again, it didn't return all the data from the specific folder. Can someone help me?

Regards,

Franz