VBA to open excel-sheets, updating link, saving and closing

[Soshi]

Hello there o/

I am struggling to find a good solution for the macro mentioned above.
I have to open over 100 Excel Sheets, updatelinks and save them.

Once they are all done every excel-sheet, besides the mastersheet, should be closed.

I have the following for the first 2 steps.

Sub UpdateLinks()
Application.ScreenUpdating = False
Workbooks.Open "N:\###\Test001.xlsx", UpdateLinks:=1
[...]
Application.ScreenUpdating = True
End Sub


I am very rusty when it comes to vba and would appreciate your help!
Happy Easter

~Soshi