Pulling Highest values in row based on name

[Devge]

I am making a dashboard in excel, and I have been stumped as to if this is doable or not. I have 2 sheets, one with data and one with a dashboard that I am making. I have the id# for each individual user in one field (g4) and use that to populate the data in the rest. I have 6 Error Columns S:X that I would like to lookup to the list to the id number in the data column and populate the 3 highest errors for the vendor number with a cell next to it with the count of cells. Is there a way to do this? Value is on g4 on the dashboard is the id# I need to lookup to match the row on the data screen.

Thanks for any help.