John, I want to thank you for your reply. The only changes I had to make were the references to the File & Sheet names used in the actual documents, other than that it worked exactly as I wanted and your efforts are much appreciated.

Thanks again,
dave