vlookup across multiple workbooks/worksheets to find specific column information

[hlynn110]

I'm trying to create a master report that already has the unique ID's in column A and I want to do Vlookup to 3 different workbooks that have multiple worksheets to pull back 3 columns. The 3 column headers I want to pull back are named the same in all workbooks but there are a different number of columns on each worksheet.

 

[offthelip]

I suggest you do it using variant arrays in vba instead of Vlookup, for an example as to how to do it see this thread:
https://www.mrexcel.com/forum/excel-questions/1043185-vlookup-vba-alternative.html
and and example as to how to match up rows and columns for copying see this thread:
http://www.vbaexpress.com/forum/sho...h-Different-Layout-by-Column-amp-Row-Headings