Hi all,
I've been trying to build to macro to copy specific files listed in an excel file from a folder and its subfolders to another folder. I am sadly a beginner at VBA. These are my specifics:

1) FSO: I would like to use FileSystemObject (unless you have a better idea?)
2) File Names: I would like to be able to copy file names into the excel (here into column "B"), e.g. "dog" but then be able to automatically copy the files: "dog", "dog_1", "dog_2", "dog_3", "dog_etc."
-> I was thinking of solving it with "*"
3) Folders named: I have named my source folder as "Start Folder" and my end folder as "End Folder"


Here what I have so far, but it's not working:

Sub Copy_Files ()
Dim FSO As FileSystemObject
Dim NrP As Byte
Dim SFolder As String
Dim DFolder As String
Dim FileNames As String

Set FileNames As Range ("B")
Set FSO = New Scripting.FileSystemObject

SFolder = "C:\...\Start Folder"
DFolder = "C:\...\End Folder"

For NrP = 1 To Packshot.Rows.Count
FileNames = Cells (NrP, "B").Value & "*"
Next NrP

FSO.CopyFile Source:=SFolder & FileNames, Destination:=DFolder

Next

End Sub


Would be grateful if you could help me out!