Jake - Thank you very much for all of your help and the new code.I have attached a file (I had never converted anything to a zip file before, it took me some time to figure out how to do it).

What is a Zip file? And why not a Excel file?

I have some questions about the code.Start on Page A, C1 and click on the Search button, type in Dog. It will take you to Page A, C3 (as it should) (It should then go to Page A C10 next).

If you click find next it goes to Page B, C13(it should then go to Page B, C20 next).If you click find next it goes to Page C, C28(it should then go to Page C, C32 next).

If you click find next it quits (it should then go to Page A, C10 next).If you type in a name that is not on the sheet it takes you Page C which is fine but if you then type in Dog, it stays on Page C, it should start back at Page A

If you tell it No on any sheet it just keeps searching and does not quit until Page C I tried to compare your code to the one I was using to find the differences to make it search all of column 3 on each sheet and keep looping, but I could not figure out what to.

Thank you for your help.