Macro Loop does not move between worksheets

Hi Everyone,
I have an Excel workbook with hundreds of worksheets of the same structure that I need to update regularly. I wrote a macro that I can run on these worksheets when stepping on them, but I would like to simplify the task further and put this macro in a loop, so I just have to click once and all these worksheets of same structure update.
I wrote the loop, but it is not working. The problem is that it is not updating any other worksheets than the one I am on when I start it. It starts flashing and runs for some time, but at the end I only get the current worksheet updated...it seems that the macro runs hundreds of times on the current worksheet, instead of stepping to all the other ones.
There are other worksheets in the workbook on which I do not want to run this macro, they all have - (hyphen) in their names, so I thought it is easy to filter them out with an IF statement.
Can someone please help me with this issue?
The code I am using is the following:

Please Login or Register  to view this content.

Hi atoga and welcome to the forum,

Edit your above post and select the code part and then click on the "#" icon above the message area. This will put code tags around the code and the moderators won't give you demerits.

Then look at:
If InStr("-", ws.Name) = 0 Then
and https://msdn.microsoft.com/en-us/lib...(v=vs.90).aspx
and reverse the "-" and ws.Name

That is just the first think I caught but without you putting your code in tags it is too hard to read.