Collect files into a folder Using VBA

[anzerman]

Hello

I'd like to know if anyone has any experience in using Excel and VBA to collect files from different folders into one.

I have an excel sheet with ID numbers in a column which correspond to file names for images. (i.e., 5943234c46a210294cd7cc4a). This is a filtered list of the larger set of images. I am wondering if there is a way to have excel search for the ID numbers in different sub-folders to collect the filtered list into one compiled folder?


I have no experience with VBA but I am looking to see if this is possible solution.

Thanks