Select data onto new worksheet
 

I am trying to create a sheet (A) that lists the 20 largest (or smallest)
companies based on another sheet (B) that has a list of companies, and need
help.

The B sheet has, in each row, many different pieces of information about
the company; there are more than 1,000 companies on the sheet. Some of the
data listed are, for example, stock price and number of employees.

On Sheet A, I'd like to have company name, city, state, number of employees,
etc., but, for example, only for the 20 largest employers. I have used the
=LARGE or =SMALL functions on Sheet A, looking in the number of employees
column on Sheet B to get the number of employees, but I can't seem to get
Excel to look across the Sheet B to find the company name or the other
information tied to that number of employees that I want to display on sheet
A.

Using a PivotTable would create a monster-sized file; I am hoping there is a
way to combine =LARGE with another function to select the additional data.

Thanks in advance for your thoughts.