vba that can compensate my vlookup work

Sir

I have a folder in which there are xls files like-A,A 1, B, B 1 , C , C 1...RAM, RAM 1....ETC...SO MANY FILES

These files have been named like this as We always do vlookup ..between file a and a1, then between b and b1.....like wise till we have files in the folder

we find what record of a are in a1 file and name it as final A, like wise for b and b1 final b....

All final file A , File B also have header with the name A, B,C,RAM....etc and total no of data rows in the folder.

Can somebody help i this regard to ease out my job else i am doing it manually by vlookup but if i get vba it will be very easy for me..

Vlookup i do as per column B in all workbooks-if data of Workbook A column B exist in data of workbook A1,column B i take data of Workbook B in final A

Kindly assist

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Originally Posted by ROHAN999

Any expert plz assist

Using loop
Or
manipulate