extract data from another worksheet
 

I have an excel spreadsheet with two worksheets.

Worksheet 2:
- has multiple entries for different companies
- it also has multiple entries for a particular company for various years

Worksheet 1:

How do I prompt the user for the company name in the second spreadsheet so
that I can provide the user only the appropriate data from the first (larger)
spreadsheet?

Example below - Data loos like the following:

worksheet 2:
Company Name Year col 1 col 2 col 3 col 4
ABC 2005 3 2 0
ABC 2006 4 7 5
ABC 2007 1 4 2

XYZ 2006 9 2 3
XYZ 2007 4 6 4
PQR 2007 1 7 9


In worksheet 1:
When the user opens the excel sheet. I want to prompt the user to enter the
name of the company. Once the company name is entered, I want it to pull the
data related to that company from worksheet 2. For example, if user enters
company name as XYZ then I want populate worksheet 1 with the following:

Company Name Year col 1 col 2 col 3 col
XYZ 2006 9 2 3
XYZ 2007 4 6 4

How do I do this?

I really appriciate your help.
Thank you.