The problem is you work only on last sheet in the last workbook. Your code must be executed for each worksheet in each workbook. For example make it part of loop starting at line 35. You may want to make it a function - that will be next step in better organizing your code. And hopefully will allow you to see that it can be simplified.
All that said you have to learn how to debug. Although it was pretty obvious this time, you may want to check the link in my signature for some general hints.
All that said you have to learn how to debug. Although it was pretty obvious this time, you may want to check the link in my signature for some general hints.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs