|I guess you are refering to MS Excel?|
Add a Checkbox whereever you want then add the following code, you may need to modify it slightly to fit your requirements
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
ActiveWorkbook.Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "New Sheet"