Looping Macro through Specific Worksheets

Thanks for the answers and I do appreciate the help. Will try it now.

Edit:

Both worked great! Thanks! Norie, how does your code work if you don't mind me asking. I've been searching VBA tutorials for different ways to work with VBA but I haven't seen anything like your code yet. My current problem is just trying to figure out how each command works without getting stuck in a never-ending loop (accidently added one and had to ctrl alt del out of excel.