Consolidate data into a master file from Shared drive int local

Hi all, I’m trying to automate a process that combines multiple data source from different excel files into one. Once it’s combined, I need to match the data with another data source to validate the data.

The problem i’m facing now is to find the filename that contains a specific keyword and copy it into local folder.

Thanks in advance!