Macro to consolidate all into one workbook

Hi all, I need some help in consolidating all the workbooks into one.
Everyday I recieve one file, showing all the trades.

I wish to consolidate all the workbooks into one Summary Workbook.
So that I can continue to do some reporting.

The daily files stores in a folder C:\trades\Mar\
The Summary WorkBook is in C:\trades\Report\

As the daily files classify the trades into different tab for different products, I wish to copy the detail over to the summary workbook under the correct worksheets(tab)

I attached an example of the daily files and the summary workbooks below.