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
and
In C15 on Ark1 enter
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.
Bookmarks