how about a vlookup on the second workbook to obtain data, then copy/paste special values to *hardcode* it in there.
then you can get rid of the first workbook altogether.
that is if there's no duplicates, else anotherfunction may work better.
edit: welcome to the board! (didn't notice it was your first post!)