Issue using Index/Match to pull multiple occurrences of "Match" criteria

Hi

I am attempting to use the Index/Match to match each instance of "Person Responsible" that is mentioned in Column D (D:D) (All tab), which have been pulled from the 'All Tab', and pull subsequent column names to create individualized lists on other tabs. The issue is that the Index/Match formula is only matching the 1st instance of the "Name" and not moving on to the subsequent matches in the search array.

Is a ROW function needed to help determine when to move on? I'm modestly proficient with excel and I'm sure it's not that hard, but any help would be greatly appreciated.

I have attached a sample spreadsheet for any possible assistance.

Thank you in advance.

Thank you for the quick response. Couple of q's. I'm on a mac, so not sure of equivalent ctrl shift enter command, though I've tried several different combos of keys.
also, this formula works on the first line I paste it in but not on the second line.

thanks also for additional info on other column formatting.

saw a notice but popup was blocked by my browser, I've disabled. please try again. thanks.