search folders/open files

[auujxa2 via AccessMonster.com]

My company currently has a manual process that needs to be updated.
Basically, I get sent an excel file every month - and with that file, I need
to update a bunch of other excel files within a bunch of folders/subfolders.

So:
1-copy range in excel
2-search/open file in folder/subfolders
3-paste copied range in cell A6
4-save
loop until all files are updated.

any direction someone can give would be GREATLY appreciated. thank you

 

[auujxa2 via AccessMonster.com]

I should add to this:

i do have VBA experience, so I'm trying to find code snipets to plug in to
accomplish this. thank you