Move data from excel 1 to excel 2 and also copy file name as sheet name in excel 2

Hi All

I would like to do the below can any one help on this
There are 10 excel with each having data in "Sheet1".
Excel 1, Excel 2, Excel 3, Excel 4, Excel 5, Excel 6, Excel 7, Excel 8, Excel 9,Excel 10

There is a MASTER EXCEL in which the data from above excels has to sit in by individual sheet and the sheet name be put as ( Excel 1, Excel 2, Excel 3, Excel 4, Excel 5, Excel 6, Excel 7, Excel 8, Excel 9,Excel 10)

SO my MASTER EXCEL will a Summary sheet (which manuall I will create to link to other sheets), Excel 1, Excel 2, Excel 3, Excel 4, Excel 5, Excel 6, Excel 7, Excel 8, Excel 9,Excel 10

Thanks & Regards
Shridhar

sample file attached

Thanks a lot Raj works perfect...

can you also help me creating hyperlinks for the new sheets created on summary sheet?

Regards
Shridhar