I'm not sure what happened myself. The first few times I ran it I did not get an error it would just seem to stop at the part inserting the information from another sheet.

After wracking my head for a bit I tried it again because I just could not understand why it would not work......and it seemed to work flawless after that so it's all good now

Thanks again for all the help.