VBA code to copy data from source workbook

[Rick Rothstein]

I moved your question to the Excel Help forum where it will be exposed to a wider audience who might be capable of answer it.