Code:
Option Explicit
Sub CopyOwnTab()
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
On Error GoTo M
Lastrow = Sheets("Master").Cells(Rows.Count, "A").End(xlUp).Row
Dim ans As String
For i = 2 To Lastrow
ans = Sheets("Master").Cells(i, 1).Value
Sheets("Master").Rows(i).Copy Sheets(ans).Rows(Sheets(ans).Cells(Rows.Count, "A").End(xlUp).Row + 1)
Next
Application.ScreenUpdating = True
Exit Sub
M:
MsgBox "No such sheet as " & ans & " exist"
Application.ScreenUpdating = True
End Sub