Good afternoon. I'm hoping someone call help me with something I'm working on. I have a file containing lots of documents, excel, pdf and word etc but their names contain a reference number.

I'd like to be able to enter a reference number in excel, then run a macro which would look for any files in a specific folder containing that reference number and group them together in their own folders and Ideally name the new folder with the reference number I entered in to excel. (there could be 3 or 4 documents in the main folder folder containing that specific reference number so I want to sperate them in to their own folders)

I hope this makes sense? Is it possible?

Thank you in advance.