Extract data from multiple files into a main file

I have checked about threads of similar problems but could not figure out how to improvise them for my case.

A Files.pngB Data in file.pngC Combined file.png

Image A: multiple files in a folder which i want to extract data from.
Image B: I want to extract range(C2:C25) from each file.
Image C: This is the final layout of my combined file. I want to fill up range(C15:Z15) with the extracted data (transposed). The file name (It can be the full file name) of the extracted data is input in the column B. And the filling will go down until all files are extracted.

Notes:
1) Actually I wish the extraction can follow my pre-determined order but the files in windows explorer are listed in different order. Which is why I need to input extracted file name in column B to avoid confusion.

Please help.
Thanks.

Thank you for quick response.
I find this add-in is good enough for my problem.
http://www.rondebruin.nl/win/addins/rdbmerge.htm