This should work. Modify the array to suit your needs.
Sub DeleteFromDate()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim LR As Long
Dim ws As Worksheet
For Each ws In Sheets(Array("Boston", "New York", "Chicago"))
LR = ws.Range("A" & ws.Rows.Count).End(xlUp).Row
ws.Range("A2:A" & LR).AutoFilter Field:=1, Criteria1:="<1/1/2017"
ws.Range("A3:A" & LR).SpecialCells(xlCellTypeVisible).EntireRow.Delete
If ws.AutoFilterMode = True Then ws.AutoFilterMode = False
Next ws
MsgBox "All finished deleting rows."
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
Bookmarks