Running macro through files in different locations?

[Rookeby7]

I hope someone can help with this:

Is there a way I can get the same macro to run for about 25areas in separate subfolders?

...\Area1\list.xlsm
then
...\Area2\list.xlsm
....
either by listing the "list" files and paths in VBA and looping through, or by another more efficient method?
(Areas have to split)
Also are there any ways to create a master list for Regions containing specific areas?

Happy Holidays

 

[Rookeby7]

I have managed to do this by setting up a folder with shortcuts,

But if someone has a better idea I would be glad to hear from you