open list of all .csv files in a folder and copy few colums in a excel of same sheet.

i need a macro, if i enter the start date and finish date. the sheet should fill the dates with every half hour interval and add the values for each eight hours .can you help this. a sample sheet is attached for your refernce in which 1st eight hour is shown, similarly i want remaining next iteration should be complete using the macro for all days and intervals.