Automatically find data from sheet and make a new sheet

[Honnett]

Even the title was hard to write, I'm not shure it's right...

I have not got the slighthest idea how to do this, I really can't anything conserning macros and VBA. I guess the answer is there, but I can't use it anyway, so I'll ask.

I have a list of EAN-codes that I need to automatically search and find in other Excel sheets, often in different files. When found I want to copy the name and the prics to the first sheet where the EAN-code is.
I need it to take code by code and find out when it runs out of codes and then stop.

Adding the EAN-code file and one of the pricelists file where I need to get the name and price.

Mikael