Formula - lookup - single cell value - return non-adjacent cell - Multiple worksheets

I have a spreadsheet that has 2 columns, the first column starts at cell C30 and is titled "Supplier Name", the second column starts at cell D30 and is titled " Quantity". In the second column I have the following formula =LARGE('First:Last'!$K$29,ROW(1:1)). This formula returns the largest value in order from largest to smallest. What I am trying to accomplish is returning the "Supplier Name" associated with the values listed in column D on the summary page.

The "Supplier Name" would be found in cell C2 on every worksheet and the value listed on the summary page (column D) would match a value listed on one of the worksheets in cell K29.

I have tried various INDEX/MATCH formulas but none of them worked, as I kept getting errors even after pressing ctrl + shft + enter.

Thank You! Works great.