How to select every 5 cells and copy it to another cell?

I would use the Index Function. Highlight your columns or range name and reference the rows part as an equation (reference a cell) and simply increment the rows by 5 next to the column on the same row that you are wanting the fifth output row (answer) to be, then range value.

Mark