Need a little help.
Starting to try an expand my Excel repertoire....

Here is the Sitrep.

I have 2 worksheets...
Sheet 1
10 names of Owners
Ex:
Joe
Jim
Bob
etc...

Sheet 2
Row headers are as follows
name owner position salary

columns of name, position, salary will have data entered but i wish to
have a drop down box to select an owner from Sheet 1.

Then i would like to be able to have to sheets 3 to 12 (one for each
owner) to have the rows extracted for the entries that are equal to the
owners name.

Ex:
Sheet 3(Jim)
would only list name owner position salary of entries from sheet 2 that
have jim as the owner.

Hope that was clear enough as any help would be appreciated


--
jpsprack