Macro for linking cells from different rows to a specific place on other worksheet

Thank You, Mike

Some Helpful Hints:

1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.

Here...