How to define Variables as Ranges and Copy them?

I want to create a Macro to be able to prepare a NEW Offer/Calculation based on an OLD Offer/Calculation.
I use 3 Tabs in Excel for this:
Tab 1: Contains the old calculation
Tab 2: Should contain the new calculation
Tab 3: Contains info about how a position in the old calculation matches a position in the new calculation.

Tab 3 is added as an attachment.

In the table A5:F22 of TAB3 the following info is given:
A the position number of the new calc
F the Range of the old calc [Tab3] that should be copied for this position.
C the cell in [Tab2] where the the calculation should be pasted (at least the cell where the range should start)

How can I create a Macro to do the following
Copy the range from TAB1 defined in TAB3 Cel F5
Paste the range starting in the Cel defined on TAB2 defined in TAB3 Cel C5
Then give the Cel on TAB2 defined in TAB3 Cel C5 the value of A5

Move on to the next row until No Values are defined in rows C and F