Adding in a cell from one sheet to another

[Stephen Sandor]

Is it possible to have text in a cell (source) as a standard and then in
another part of the workbook, via a tick box, select the source and insert a
row (with the source text) into another sheet that forms a part of a report?