!!!Extract certain cells (both value and string) in multiple workbooks and paste them into one summary sheet

[WonderlandBOS]

Hi,

I am a very new employee in the company and just started learning VBA. Now I have a project to write VBA code and create a summary sheet by dumping tons of data from multiple workbooks. Here are some criterion I would like to meet:

1) I copied value and date(like 09/08/2016, Sep 8, 2016) from each workbook
2) The cells of date and value are in different rows and columns
3) the source files are .xlsb and the summary sheet is .xlsm.
4) The summary sheet will put them in time order from oldest to newest.
5) try to not open source file

Thank you so much. Really need Help !!!!