It isn't really possible to attach a workbook because the links won't work.

Imagine worksheet1 with a lookup table: in column A are 10 rows with letters A - J, and in column B are document names. The document names link to a file, but that file does not have the same name as what appears in column B.

In worksheet2, column A has hundreds of rows, whose entries are a letter between A through J. I want to basically look up the contents of column B in worksheet1, including the links, and put them in column B of worksheet2.

Does this clarify the question?