Excel compare data and rank in order..

Hello,
I have an excel spreadsheet that has 4 different tabs of data for each individual (same parameters with different data values), can Excel do a comparison of the data to show, based on the data, a ranking say from the least to the greatest or vice versa? So which manager has the highest averages for cases reviewed, least amount of errors, least amount of late cases, etc. and rank them in order for each parameter. I have the excel sheet attached and am trying to get this functional in the "Consolidated" tab. Appreciate any inputs on how this can be done.

Thanks.