Thank you for your help here! As you probably figured out, I'm not
that great at actual coding, but BOY can I pretend to code using
macros! *sigh*...

I have very slightly modified the code above, replacing the sCellref
value "people" with a named range name and the file and path names to
point to my files.

I keep getting an error messag that the source or object is read only
when running the script. I have also noticed that the rDest never
seems to get a value assigned to it..the script gets through the
script to the line:
Set rsCon = CreateObject("ADODB.Connection")
but then seems to error out on the next line:
rsCon.Open strConnect
and jumps to the errExit line, which then gives the above mentioned
read only error.

Thank you again for your help!