Loop issue

Hi,

Yesterday I posted a loop question and several of you answered it quickly. That solved my problem and I thought gave me what I needed going forward. However, when I tried to make another loop work today something went a little wrong. I have attached a workbook named "Test". Within that workbook there is a macro named "Test" (code below). What I would like it to do is loop through the workbook performing the macro on every sheet. What is happening is that it is running the macro over and over on the same sheet.

I think the code might a bit longer than it should be to perform the macro. I'm getting better at cutting it down but I don't think that would have anything to do with the loop issue would it?

What am I doing wrong? It is looping but not moving to from one sheet to another.

Thank all so much for your help and time.

HTML Code: 

That was the problem. Thank you so much. Of course it would keep looping on the same sheet. By using Activesheet I was telling it to do that. Couldn't see the forest for the trees I guess.

Again I thank you so very much.

Eddie.