Combination sumproduct and rank, I think?

[daniels012]

Over all i want 3 sheets of data listed on my main sheet.
Each individual sheet has a salesman's name the main sheet is called "total sheet".

I would like to combine jobs listed from each salesman's sheet by there rank on the total sheet.
On each sheet the "company name" is in Column A the "dollars" are in Column B and the "rank" is in Column P.

If this is an impossibility, please let me know that!
I really don't even know how to start a formula like this.

Thank You,
Michael

 

[daniels012]

Column P is actually a percentage we enter, so in essence we are ranking them using a percentage.

MIchael

 

[daniels012]

bump

 

[daniels012]

Is this possible or is it more work than necessary?

 

[jmthompson]

I think you will need to provide samples of each existing sheet and a sample of the desired outcome before anyone can help