LO Calc Paste content from multiple cells in to one cell with Macro

I want to use Macro to copy content from for example 5 cells in to just 1 single cell. The recording tool doesn´t record anything when I dubble click on the single cell and paste.

The content from many cells will surely require a kind of accumulating before it can be pasted into a single cell. How should that be done? Is your content ‘Number’ or ‘Text’ or mixed? Are the cells assured to be contiguous? In one row? In one column? Donno?
Why do you want to use a macro? In what way shall the macro get the information about what cells to work on? …