Merging Data from Multiple excel sheets to a Master sheet

ICP_Amit Ranjan.xlsCP_Anup Gavankar.xlsAttachment 284511CP_Hitesh Chaurasia.xlsCP_Manas Mehta.xls

I am very new with VBA code (about 5 days old). I am using Excel 2003. This question is to help me in my job.

Question: Here i am having 20 time sheet entries of different team mates are in different excel sheets, and i have a master sheet, in that i need to copy data from every excel sheet Team mate name and project and no. of hours.

Please find attached excel sheets.

Please help me ,