Daniel C wrote:

I need help coming up with a macro that you can search for files that
match a certain criteria that may be in various folders/locations, copy
them, and then paste into a new destination.

It depends in part upon the criteria. Expand upon "certain criteria" and
you'll get a more meaningful answer.

--
I hope you're at least getting some amusement
out of this waste of bandwidth.