Copying across from master sheet to subsequent sheets

[p_d_b]

Hi all,

What I want to do is the following:

Master
- Have an initial master list sheet, with data input all in this sheet
- Have the ability to select a row and then click a button and move that entire row to a specified row in the next sheet, and delete the source row

Closing (2nd sheet)
- Once across from the master and in the specified row on the 2nd sheet, have another row CONCATENATE two cells together
- Have a button that moves that entire line to the next available line in the third sheet and clears the row (not deleting the row)

I've attached an example

Thanks