Macro to pull data from files in the folder with skipping processed ones when using again

Hi all,

I adjusted the code I found on the Internet to pull data from the files in the folder and put them in one master sheet.

However, the numer of files will grow very quickly every week, so for that reason I would like to implement in the code that macro will skip the files that were already processed. I would like to do it by the looking up the file name in the master sheet (column U).

Please find the code below:

Please Login or Register  to view this content.

I tried to make it by If and GoTo statement but I have very little knowledge in VBA and I have no idea how to actually formulate it skip files which names are already in master sheet.

Thanks in advance!