Macro to copy data from one sheet and paste onto the next available column in another spreadsheet

[geddes_1310]

I have 2 worksheets in my work file. One is call "Sheet 1" and the other is "Summary". The "Summary" worksheet is supposed to be a monthly cumulative worksheet.

So every month, I would need to override the data in "Sheet 1" and have the data of specific cells to be copied to the next available column in the "Summary" worksheet so that the 'Summary' worksheet shows a monthly cumulative data.

e.g:

Month of Apr
1. AG4 to AG9 (in Sheet 1) to be copied and paste special in F8 to F13 (Summary)
2. AG12 to AG 17 (in Sheet 1) to be copied and paste special in F16 to F21 (Summary)
3. B168 to B172 (in sheet 1) to be copied and paste special in G8 to G12 (Summary)
4. C168 to C172 (in sheet 1) to be copied and paste special in G16 to G21 (Summary)

Month of May
1. AG4 to AG9 (in Sheet 1) to be copied and paste special in H8 to H13 (Summary)
2. AG12 to AG 17 (in Sheet 1) to be copied and paste special in H16 to H21 (Summary)
3. B168 to B172 (in sheet 1) to be copied and paste special in I8 to I12 (Summary)
4. C168 to C172 (in sheet 1) to be copied and paste special in I16 to I21 (Summary)

How do I write a macro for the above?