Good morning!

Please note that I’m quite new to VBA in terms of serious projects. Basically I’m just trying to figure out if a project on which I want to work is even possible and, if so, what the best way to go about it would be:
I have a folder full of .xls files which need to be distributed into other folders based on a number/letter string the middle of the filename.

However, the specific folders into which they need to go is determined by a spreadsheet. The spreadsheet doesn’t say where the files need to go but it does say what properties the files have which would determine into which folder they’re being sent (ex: gender, department, etc.)

Is it possible to integrate a macro into the spreadsheet with the properties, find a filename with the correct number string and then send that file to another folder? If so, what’s the best way to go about it?

Many thanks!