I have a section of code that does not look at all sheets when it runs the second section of the code. It runs correct with the first section and when it runs the second section it only looks at sheet1 and ignores the other sheets. When it moves to the next file it runs correct again with the first section of the code and on second section it only looks at sheet1 again. I need this code to look at all sheets every time. I have attached the current files I'm using to test this and I have marked my problem in red where it should have looked at all the sheets like in the sections above it.