Looking and regrouping informations accros sheets

[Hakimipous]

Hello,

I'm working with a lot of excel files currently, and I have to link information across different sheets

For example, in my 1st excel file I have a sheet containing a name, and in an another sheet I have the name with an ID  number (the rest of the sheets are not relevant )

So the I would like to create a macro that could regroup those information together

Like, in Sheet 1 I have Mat + Some useful info, and In Sheet 2 I have Mat 0098. Rest of the sheets can be ignored.

Result should be a table With the info from both sheets 

Could that be done? 

Thanks !

A Macro beginner

[Hakimipous · Accepted solution]

Solved the issue thanks to the awesome  Crew Macro package

http://www.chaosreignswithin.com/p/macros.html hope it may helps others in the need