I'm confused, worksheets have nothing to do with userforms.

I think you want something like:
Private Sub AddCand_CommandButton_Click()
    Dim m As Object
    Set m = MultiPage1.Pages.Add("Candidate2", "Candidate 2")
    With ThisWorkbook.Worksheets.Add
        .Name = "Candidate2"
    End With
End Sub