The most important thing in computer programming is "Loop". Humans hate repetative work and computers love them. As long as you can do loop, you are fine.
Private Sub test1()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.Name
'Insert your code here
Next ws
End Sub