the problem might be that they are not part of the same file/project... you can easily import the data from one file into a sheet in the other workbook tho... that's just a simple copy/paste routine in VBA

import it, process it, and then delete it

have you tried testing it with both sheets in the same book?

VLOOKUPs really suck