Hi,

Thank you so much for reading and helping me out. Here is my issue.

So I have two sets of data on two different spreadsheet.
Let's call them A and B

I need my new spreadhseet; let's call it C
to have the following:

When the PEIN (Field) is typed in at Spredsheet C,
it should use the PEIN as a search keyword; it needs to find
the exact match of the PEIN in spreadsheet A and B

In both A and B, the PEIN maybe duplicated; but it has with different information on the same field
(Let's say, the dates are different, or the amount of the commission is different).

Assuem this:
Spreadsheet A, PEIN ABC123; it has three matches.
Spreadsheet B, PEIN ABC123; it has two matches.

Under each match, there are different fields on the same row; let's assume
"Order" "Date" "Commission"

What I want to do on Spredsheet C is that
when i put in PEIN, it will shows me all the fields
on Spreasheet A, and B Associated with the PEIN.


Further more, it will create tap for me after I run the Macro; Tab name can be the PEIN number.

So basically, I need a Field that can put in the PEIN, a button that generates the information that will
create another sheet for me with the information I need.

Thank you for helping once again, It would be cool if you can let me know where i should start or writing this code for me. most likely i will need to do some modification on it.