Contact Log Macros

Hello everyone,
I'm looking for some help creating a macro for a contact log using excel 2010. I used to do this another way but its just not going to work. Basically what I am doing is transfering data (phone numbers, addresses, names, etc), from one Book, which we'll call Book 1 for out purposes, and pasting it into the approrpiate cells in Book 2. Each person's info is listed in a single row in Book 1. However, Book 2 is a formatted Contact log, so each person gets one whole worksheet. I created a macro as a test and it did exactly as I wanted for one row. But that is the problem. it copied the correct data from Book 1, row 2, and then inserted it into the appropriate cells in Book 2, Worksheet 1. But now I need row 3 from Book 1 to go into Book 2, Worksheet 3 and so on. The sheet and row names will not always align either. Is there any way to do this?

I used to do this with a scripting program that copied my clicks and keystrokes copying directly from a website, but its just not working anymore due to site changes.

Any help would be greatly appreciated. A macro is the difference between a 2 hour job and a 10 hour job

Here is the macro I created as mentioned:

Please Login or Register  to view this content.