Sum same cells - closed workbooks - different folder

Hello,

Can Someone help me with this:

I want to sum the same cell (M1) from closed workbooks.


The main directery = U:\hours\

Each excel file has his own directory
week 01, week 02 enz

So week 01 file = U:\hours\week 01\week 01.xlsm
Week 02 file = U:\hours\week 02\week 02.xlsm

Cell M1 = always the total of each week.


I would love to have a excel file in the main (U:\hour\) where all totals are listed

So
A: B:
Week 01 total cell m1
Week 02 total cell m1

And so on.


Thanks

Ok thanks,

the problem =. Those files are 1 on 1 dumps from software.

The total is not refreshed if someone makes another dump.