search for a file in a folder based on data, copy and paste it in another folder

Hi guys,

What I am trying to do is have excel read a column of cells from a query table data source, say something like (Table_Query_from_Software_1[Column], search the value/text of each cell in that column in a specific folder in a Network Drive (I:\Folder\Subfolder) for a .zip file, copy and paste it to a folder in another drive (H:\Folder\Subfolder) all the while having a message window run through a status of each file (i.e. for each file, if it is there give it a “Found!” and then a “Successfully Moved!” message, if it can’t be found then a “Not Found!” message) I realize this last part may not be possible/ a lot to ask. thanks!