Macro to gather multiple pdf files from multiple directories on a

I am seeking a macro or gui to gather multiple pdf files from multiple
directories on a network drive.  For example, I would like to run a
macro that will read in a BOM (in some format-probably a csv file),
then search several directories of a network drive for the
corresponding pdf files (component number e.g. 12050-123) and copy the
pdf's into a single directory.  Then I would like the same macro, or a
different macro if need be, to print the pdf files from that single
directory.

I realize that this is not directly a SW post however it is a
downstream process that is related to SW.  Any help is greatly
appreciated!

Thanks