|...Dad Mode On...|
Single step through the code I sent you in response to your very similiar question the other day.
Once you understand how it works, modify it to work across sheets.
Use the VBA help files by placing you cursor on a word in the code and pressing F1. By figuring it out on your own, you'll learn a whole lot more than if someone just supplies the code.
If you have specific questions about syntax, come on back and we'll see what we can do.
...Dad Mode Off...