VBA-Loop through File highlight sheet tabs that are still empty

[TheHack22]

Dear VBA experts,

I'm not sure if this is possible. I don't know how to write VBA. I usually do a google search and adapt Subs.
I have a VBA that copies daily data downloaded (15 Files=15 Tabs-Template) files onto an MS Excel Template.
Sometimes, I may miss a download(s). How can I have a message box to say which sheet data (SheetName) wasn't copied to? The data range A3:G(100). the datasets are huge. But once A3 is populated it's a good indication I have the data for that Tab. Is this possible?

Imran

 

[BSALV]

when do you miss a download ? Can't you open a certain file or is the file empty or doesn't exist or ...
For the moment your macro already makes that loop, but you have to add the missed sheets ?