I’m trying to copy 16 cells located in various places on sheet1.

A1
B6:G6, I6
B9:H9, J9

Paste them to the last row on sheet2.

A1:P1

Can anyone help me with this.