I am wanting to set up a worksheet so a user can click a check box (or
whatever the best method would be) and copy that row to another worksheet in
the workbook (or another workbook) in the next cell down each time it is
checked.

i.e.

()A B C
1 2 3

checking the box would copy 1 2 3 to the worksheet/workbook of choice in the
next empty row.

Thanks