Pulling Top 5 Highest & Lowest Values of Certain Type

Hello, looking for a way to utilize maxifs/minfis or index a specific way, there are probably a hundred ways to do this, i just do not know the best one. If you open the file i'm just looking to pull the top 5 highest and lowest values by type. If you look at column "C" it is comprised of R,F,P. Is what i want to do is make a dashboard to the left that every time i load the data in there it just updates my top 5 and bottom 5. I would need it to fill the right hand side of the sheet I.E. Material description, Material #, Value etc.