I am trying to merge two worksheets together.

my first page has customer names,address,phone number, city, country.
The second page has each person's order they have made.

What i want to do is. On page one, if i double click John Doe, I want all of
the orders he has made to pop up. Instead of opening up two seperate forms
each time!.

I hope this makes sense