VBA Vlookup code in excel

[shehla]

Hi Everyone,
i need support to write a excel vba code on vlookup of all sheets with different name from first sheet name"Sheet2" and put the information accordingly. number of sheets can vary. number of rows in every sheet can also vary. master sheet"sheet2" cloumns detail can also vary. all sheets numeric numbers will find the data from sheet2 and paste the desire information right above the numeric boxes. picture is attached for reference. looking forward for kind reply.

 

[shehla]

image is attached for reference.

 

[shehla]

image is attached for reference.

dear All,
it would be great if someone can help to provide the solution

 

[shehla]

dear All,
it would be great if someone can help to provide the solution

hoping to get response from intellectual minds.

 

[shehla]

how to add vba code to vlookup horizontally and fetch the data from sheet 1 to main sheet