In the attached is a button in the QAT USE sheet near cell C21 labelled Update Log Sheet.
The code it calls is in that sheet's code-module. If there is more than one instance of the serial number on the Log sheet it finds the last (bottom-most) one.
Sub blah()
Set x = [Table1[Serial Number]]
Set y = x.Find(what:=Range("C10").Value, after:=x.Cells(1), LookIn:=xlFormulas, lookat:=xlWhole, searchdirection:=xlPrevious, searchformat:=True)
If y Is Nothing Then
MsgBox "Serial no. " & vbLf & Range("C10").Value & vbLf & " not found on the Log sheet"
Else
If Application.WorksheetFunction.CountBlank(y.Offset(, 4).Resize(, 3)) < 3 Then
MsgBox "There is already data on the Log sheet for that serial number" & vbLf & "Going there now…"
Application.Goto y.Offset(, 4).Resize(, 3)
Else
y.Offset(, 4).Resize(, 3).Value = Array(Range("C6").Value, Range("C8").Value, Range("C14").Value)
MsgBox "Log sheet updated"
End If
End If
End Sub