Macro to take action on all sheets that come after specified sheet

Hi everyone,

I have an excel Workbook made up of sheets that are named after months ("May 2014", "Jun 2014" etc). I want to pull data from each sheet that comes after a user specified date. Is there any way to do this?

Thanks in advance!

Emma

Does this help?

Sub Emma091()
Dim x As Long
Dim y As String
Dim i As Long
y = InputBox("Please Select The Start Sheet")
Sheets(y).Activate
x = Sheets(y).Index
For i = x To Worksheets.count
Sheets(i).Activate
 'DO SOMETHING
Next i
End Sub

Ahh so you can specify sheets by number rather than by name. Interesting.

That's really helpful, thank you John

You're welcome. Glad to help out and thanks for the feedback.