VBA - Link in code to get data from one sheet paste in another sheet.

Thanks for the change of title.

If the relationship between cells on Ark1 & Ark2 I think you've answered your own question.

In C5 on Ark1 enter

Formula:

='Ark2'!A1

and
In C15 on Ark1 enter

Formula:

='Ark2'!B5

Normally the easiest way to get stuff from one sheet to another is to use an Advanced Data Filter but this may not work for you since the output needs to be in a 2 dimensional table.

If there's some sort of calculation that given a cell row number & column number on one sheet it will result in the relevant row and column number on the destination sheet then you could use a macro.