Offsetting excel formula

[drop05]

I have code to where it takes a table and makes exact copies of them one after another.
sheet one has a table that is 16 columns and when I run the code it will past the same 16 columns, for example A-P is the 16 then it leaves Q empty then pastes the 16 starting at R and so on
Sheet two has 3 columns being used. So a-c leave d empty then start on e-g so on
I have a formula in sheet 1 in cell C5 is =‘sheet2’B5, however when I run the code it then pasted in S5, the correct spot, but adds 16 so then the formula changes to =‘sheet2’R5 when I need it to be not adding 16 columns over but I need the formula to be =‘sheet2’F5 so far so on

is there an excel formula to help?

 

[aRandomHelper]

Show what's your code doing, is it simply copy/paste? is the formula inserted by the code?

I have a formula in sheet 1 in cell C5 is =‘sheet2’B5

is this the only column with formula?