VBA to extract & combine data from multiple excel file from a specific folder

[Samiul]

I need to extract values based on some fixed matching criteria from multiple worksheets in the same workbook and paste the values in a separate active worksheet in specific rows/columns. For example in the attached image I would like to extract data from the rows having values of direct shear test & put it in another worksheet including the mean of value of the recorded data. How can I do that using vba macro. Capture.JPGCapture.JPG