Mergring two sheets information together using a search word by applying macro

Hi,

I need help on getting a macro that can use the PEIN as the search word to display the information onto one work sheet from two different files.

basically, i need information from nekken22 and nekken23 files searchable once i put in PEIN in cell A2; or by any design that make sense. When the PEIN matches, it will display all the records (keep in mind, the PEIN might duplicate on either file).

Further more, if the results can use the PEIN to create a tab by itself on the worksheet, that would be fantasic.

I think i underestimated how hard it is to write my own codes.

If you are helping out and have questions, please ask.

Thank you very much in advance.

Nekken22 (see attachment for information; i am using the exact format; therefore it would be great if it can be linked up into one file)

Hi Nekken,

I don't understand what you want - can you supply a sheet that shows your desired result?