Extracting data from table using VBA looping

[TexasBobcat]

Column A:E is the data I am using in an attempt to create a table with VBA.

Column G should be $A$1 and Column H should be $A$2. Column J should correspond to the data as presented in the picture.

I was able to loop my duration to 100 which I wanted, but that is about as far as I have gotten.

I was able to loop PlanName and IssueAge but I hardcoded the data, which I don't really want to do because the issue age will change after the duration 100, and will begin again at 1 again for the new issue age.

Factor for duration 1-5 should be row A3:E3, factor for duration 6-10 should be row A4:E4, so on and so forth.

Eventually there will be a new issue age of 11 (all the way to 65), and new duration (for each new issue age). I would like to create a VBA to loop so I won't have to do much inputting, but this is my first attempt at VBA and I'm stuck.

Reserve Snippet 2.PNG