macro to import specific sheets with value in a file

Hi,

I need your help again, I have some 25 files in a folder like File1,File1,File3,File4 etc. each file has many sheets, I am trying to create a new master file from the sheets of these files.

I take some sheets from these 20 files and create my master file.
everytime I open each and every file move sheets to my master file then do a copy paste values.

Is there a way in macro where I will give all 20 file names with the path and the sheet names from those file on the code so each time I run the macro the sheets are imported to my master file.

I have attached a excel file with details.

Cross post is here : http://www.mrexcel.com/forum/showthr...36#post2110636