Macro to copy data from different workbook and summarize it to a different workbook

Hi,


I created a time sheet for each employee (10). I ask them to fill up an excel file located in a same shared folder. I attached a sample here as Source1.xlsx and Source2.xlsx. I need to summarize the time sheets in a systematic way. The easiest way I can think is to create a macro to open each file (all saved in just 1 shared folder) and copy the contents of this time sheets which is always on the first sheet/tab of each source. I need the data to be copied in a summary workbook to a sheet named as "Data". This data should capture also the sheet name from the source file (employee ID) to a separate column. I attached a sample of the summary result. In the actual summary I have, this "Data" is my source for my graphs and other analyses so I need to paste values only from the sources under the correct columns.

Please help.