Macro's are irreversible, make backup of file before using macro. Better save then sorry.
I created to sheets: Data and Completed.
Both sheets have header in row 1.
Data sheet has 4 columns of data, Completed sheet has 3 columns of data (minus the completed column.).
Right-click on the sheets tab and select view code. Paste the following code in the window that opens:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lRow As Integer
If Intersect(Target, Range("D2:D" & Rows.Count)) Is Nothing Then Exit Sub
If Target.Value = "Yes" Then
Range(Cells(Target.Row, "A"), Cells(Target.Row, "C")).Copy
lRow = Sheets("Completed").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Row
Sheets("Completed").Range("A" & lRow).PasteSpecial
Application.CutCopyMode = False
Test code by entering Yes in column D of Data sheet.
Also consider the option to apply dropdownlist to enter Yes with two mouse-clicks.