I'm looking to write a macro that pulls a table from a "Book1.xls" into a
template where I can copy and drag a VLOOKUP function to find specific data
in the table. I've expanded my limits trying to build a macro that (A) pulls
data from an open workbook and (B) is able to copy the function down to the
end of the table as it's row count varies everytime.

Any help would be greatly appreciated.