Create worksheets from Excel list

Hello,
I've come across the following program to create worksheets from a list in Excel - can someone further explain the steps I need to take to implement this program? I've never done anything like this in Excel before. Also, what I'm looking for is a workbook with a worksheet for each date in it, with the date appearing on the tab and also in the first cell of each tab/worksheet.


Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range

Set MyRange = Sheets("Summary").Range("A10")
Set MyRange = Range(MyRange, MyRange.End(xlDown))

For Each MyCell In MyRange
Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
Next MyCell
End Sub