How to make one summary file with 29 sum up sheets

Hi

My self Dr. Seema Mehrotra working as an Urban Economist at National Institute of Urban Affairs, New Delhi, India. I am working on a very large data set. That consist 4000 excel files and each excel file consist 6 sheet. These 4000 excel files are saved in 29 different folders and these 29 folder are a part of one folder named 'Claims'. Now I have to make one summary file with 29 sum up sheets based on 4000 excel files.

I had already create a master summary file with one menu sheet and 29 sum up sheets. The menu sheet consist 29 sum up sheets name and we have to select from drop down menu.

Folder 1 - Named 'Claims'
Path c:\Claims

Folder 29 Named such as AP, MP, UP Uk, Raj etc
Path C:\Claims\AP
C:\Claims\MP

Excel files 4000 Named such as AP_Hyderabad_PG17-18
AP_Guntur_PG17-18

Path C:\Claims\AP\AP_Hyderabad_PG17-18
C:\Claims\AP\ AP_Guntur_PG17-18

File Name MP_Bhopal_PG17-18
PathC:\Claims\MP\MP_Bhopal_PG17-18

All the 4000 Excel files consisting 6 Sheets. Sheet one is instruction and rest 5 sheets consisting data and protected with password.

Master file Named Master Summary
Path c:\Claims\Master Summary.xls

Now I have to fetch (copy) data from each file to be paste in summer file.

Please Help me how to write a macro for that.

Regards

Seema