Macro to to merge data from list of rows

[mapleleafs2412]

hello

I have a list of items that I would like a macro to repeat untill of the rows have been completed
In the spreadsheet
I would column row A3 to add information in c3 and add the value in C1
repeat the information with A3 now going to e3 and e1

repeat the process until all columns have been captured and put the date

repeat for A4

complete when all rows have been actioned ( there could be 1000 rows)

toe out put tab shows the outcome

Your help is greatly appreciated