Match/Lookup/Result Formula

I need some help in creating a formula that will match a number and lookup the highest total then return this result “Name & Amount” into another worksheet.

I have create an example worksheet

Thanks ahead

In C5:

=MAX(INDEX(Sheet1!$B$3:$G$10,,MATCH(B3,Sheet1!$B$3:$G$3)))

in D5:

=INDEX(Sheet1!$A$3:$A$10,MATCH(C5,INDEX(Sheet1!$B$3:$G$10,,MATCH(B3,Sheet1!$B$3:$G$3)),0))


copy to other week results.