Macro for copying csv

HiGuys, need help to write a macor:

Here is my requirement.
I have a daily Status Code report which has 5 sheets
Sheet1:- Overview - This has calculations from other 4 sheets
Sheet2:- Today- This has todays order data which I want to import from a orders.csv automatically
Sheet3:- Yesterday - This should have yesterdays orders which we currently manually copy daily from Today's sheet before overriding it with today's Order
Sheet4:- Today's Outstanding Order - This sheet has todays outstanding orders which I want to import it from outstandingorders.csv automatically
Sheet 5:- Yesterdays Outstanding Order- This should have yesterdays orders which we currently copy daily from Todays Outstanding Order before overriding it with Todays Outstanding Orders

What I want:
A Macro with following steps,
1) When the excel is opened, clear Sheet3 and Sheet5.
2) Move Sheet2 data to Sheet3
3) Move Sheet4 data to Sheet5
4) Automatically read the orders.csv file from its location (Local) and copy data to Sheet2
5) Automatically read the outstandingorders.csv file from its location (Local) and copy data to Sheet4
6) Sheet 1 which uses this 4 sheets expected to calculate on its own.

Can anyone help me on writing this macro.
My knowledge on macro is zero.

Have attached Status Code report and the sample csv files (zip file) .Please note that number of records will differ daily in the csv files.

I appreciate all the help.

Thanks
Jignesh