Copy cell values (not formulas) from a pair of rows then paste in a new set of rows

Hi,
I am new to this forum even though I have been a frequent visitor over the past couple of months. I am a mechanical engineering student and only have experience in excel and programming in VBA from work. I am tasked to produce a cash flow report that needs to be fluid in the sense that payment percentages need to be able to be moved to different months (columns) in the same row it is being pasted in by changing the lead time. Also if someone could help me figure out how to get the last payment percentage to match up with the month on the "Supplier Input" tab that would be greatly appreciated as well.

Thanks,
Nate