Tweak MS Excel VBA Macro

I need a VBA script that reads the MS Excel workbooks in a particular folder and extracts values from one of the worksheets on each workbook to a separate Summary workbook. The workbooks are identical in structure, but each may be called by a different name as they are from many different users. I have a script that does the extracting of the data from the workbooks, but I need a VBA Excel guru to make it so that it displays the extract on the Summary workbook so that each extract has a summary line in the Summary workbook. The merge file (attached) has the VBA code. The statrep file is the file that the data needs to be extracted from and the summary file is the format that the extracted data need to be displayed in. (see attached) I need confident and knowlegeable excel experts who are able to turn this around for me very quickly please. If you are not very skilled in VB/VBA, please could I ask you not to bid for this as it is an urgent task and requires a quick pick up and turn around. Thanks