Extract information using VBA or Vlookup

[g3org]

Hello everyone,

Can someone help me to extract some information from sheet. The code needs to take the name from A2 and search in the sheet with the same name, ant to take info from a specified cell. In the end in the Overview sheet i want to have all the names with all info from the cell next to their names, from the sheet with the same name. Thanks in advance for your support and have a nice day.

 

[Peter_SSs]

Try this in cell B2

=VLOOKUP(A2,INDIRECT("'"&A2&"'!A:B"),2,0)

 

[g3org]

Thank you so much, works perfect!

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.