Changing the structure of the files

[Moriexcel]

Hello members,
I would appreciate if you could help me to change the structure of all my *.csv files to the following format and write them all in a single .xls file.
I tried to solve it by myself, but I didn't know even how to record a macro for this specific case.

INPUT FILE STRUCTURE (*.csv)
2-15-2015 4-03-41 PM.png

OUTPUT FILE STRUCTURE
** for the dates that there is no value (e.g. 30 & 31 Feb), you can leave it blank or fill it with "?" or "-999" as missing value.
2-15-2015 4-05-04 PM.png

Thank you.