Import .xls file in .xlsm file using macro and vlookup the sheets in new sheets

Hi,

I want to import 2 .xls file "BW GL .XLS" & "ECC GL.XLS" in "PP.xlsm file". After importing in need to vlook up those file based on "GL_ACCOUNT" column in "BW GL.xls" and "G/L acct" in " ECC GL.XLS" into new sheet called "Reconcile"

I am able to import the .xls file but after importing i m not able to perform the vlookup on it.

PP.xlsm has "Button 3" where i have written the macro code.