Extracting Data Subject to Conditions

Hi,

I have data in sheets "firm 1" and "firm 2" and would like to use formulae to extract the top and bottom 5 performance for each sector as shown in Sheet1.

The formulae in column B in Sheet1 would have to look in both adjacent sheets and return the largest and smallest 5 values for each sector and then formulae in column A would return the names associated with these values.

Can someone please suggest formulae to accomplish this.

Thanks!