Without actually setting this up for myself, I am not sure how much more help I can offer.

Do all of the spreadshhet files already exist?

Have you tried using breakpoints to check that everything is being set as expected?