VBA Guidance - how can you run code on multiple sheets.

[LNG2013]

Hello, more guidance than anything - what is the best way to run VBA code on multiple sheets. All sheets names are Data01, etc they are sequential.
I am looking to create a Pivot chart on each from the data that is present.

More details are here of what I am trying to do: VBA - Multiple Sheets - Create Pivot Charts on each sheet

 

[steve the fish]

Heres a possibility:

Sub ThroughDataSheets()

Dim sh As Worksheet

For Each sh In ThisWorkbook.Worksheets
    If UCase(Left(sh.Name, 4)) = "DATA" Then
        'do stuff
    End If
Next

End Sub

 

[LNG2013]

Thank you trying this.

Follow up if I wanted to add a Pivot table to each one of those sheets what is the best way for that the data is from A2 to end of H