Copy multiple cells from one sheet to a specific locations on other sheet

[Milchika]

Hi,
As the title says, I need to copy several cells from one sheet to another but in a specific order, and repeat that function quickly. I am looking for the quickest way to do it, preferably a formula or smth. Here are two pics that will explain my issue more vividly. I am trying to copy cells from upper picture to the lower one... Colors indicate where a certain cell needs to be copied (only highlighted cells need to be copied), and simply repeated on the next row...and so on... I hope I was clear enough.

-Thanks

8f7e13e2cc.png


b5a38b5b5f.png

[daffodil11]

B1:
=INDIRECT("Sheet1!A"&INT(ROW(A1)/5)+3)

Continue pattern, changing Column Letter as needed for each input. Once block 1 is done, entire blocks can be copied down.

[Milchika]

Yep, that did it. Thank you very much!

[daffodil11]

Merged cells can present a lot of interesting challenges to formula building. It's even a little worse in VB.

But hey, I love a good challenge.