don't understand why you need to link anything

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