Macro asking to select the folder and open file.

Dear All,

On monthly basis, I have to update excel file from files prepared on daily basis. ( ie to select 30 different sub-folder and open 30 different files ).

Kindly let me know the macro which will ask me to select the sub-folder and open the file --> copy the data --> Paste Special the data in monthly file --> Close the file.
Again ask me to select next sub-folder --> copy the data --> Paste Special the data in monthly file --> Close the file.
And so on ...... till reached the last sub-folder.

My email Id : [email protected].

Thanks in advance.