you could have your VBA macro read the rows in the Excel sheet one at
a time.
For each file name use the InStrRev function to find the base name of
the file (ie to strip of the drive and folder part of the file name)
then use the FileCopy statement to copy the file from its original
location to the target folder .

Catherine