I need formula of vlookup for multiple workbooks

Mohammed Kamran (Accountant) (23 Points)

12 April 2017  
Hi I have a data in one of the excel file which a need to compare with multiple workbooks. The problem is that all the file are not having same number of col. and heading. I would like to know what will be simplest way or the formula for vlookup