Need to Combine Index, Small(If with an Or

I have a coworker that maintains a spreadsheet comprised of several tabs, the first is the main and contains all the information about each business partner with columns showing their 1st choice wholesaler, 2nd choice, 3rd choice and so on. And then there's a tab for each of the wholesalers listed on the main page. I've been asked to automate each of the wholesaler tabs to automatically populate with the partner name and contact information regardless of what order that wholesaler was chosen. The problem with index(match is that it picks up the first instance of a partner and repeats that name each time that partner shows up with a different wholesaler name. So I did sort that out with this formula and it works perfectly....for one column of wholesaler.

=IFERROR(INDEX($B$6:$B$8,SMALL(IF($G$6:$G$8=B17,ROW($G$6:$G$8)-ROW(INDEX($G$6:$G$8,1,1))+1),A19)),"")

But I have 6 columns of wholesalers and I can't figure out how to make this work for each instance of partner listed vertically and then make it work for each wholesaler listed horizontally. I've attached an example spreadsheet, but can't figure out how to expand this from just Column G. Ok I tried to attach spreadsheet, but the icon isn't working. I've attached a pic.

Attachment 507607

Any help is greatly appreciated!