Excel macro for search pdf file and copy to destination folder

Hi,

Need help to create the macro which can search pdf files with file name mentioned in excel column which can search file in the source folder and copy to destination. The file name mentioned in the column will be checked against initial 8 text/number (XXXXXXXX...) if matched then copied to destination folder and those file name not matched it listed on another column or show list of not available file.