Copy 5 columns and paste to next 5 columns

Hello,

I have to run daily reports where I have to add new day data to the right end of the spreadsheet. Example is below. I want to create a macro that will automatically do that.

A1 B1 C1 D1 E1 I want to copy datas in the those 5 columns and paste to the right
: : : : :
A9 B9 C9 D9 E9

I want to copy datas in the those 5 columns and paste to the right end of the spreadsheet.

F1 G1 H1 I1 J1
: : : : :
F9 G9 H9 I9 J9

Next day will the the info above and copy to

K1 L1 M1 N1 O1
: : : : :
K9 L9 M9 N9 O9

Can someone help me with this. Thank you in advance.