Changing Names in Formula

[BriCris]

I'm looking for help setting up a formula that will change with manager names from the helper page. The formula need to work when there is More or less managers ie. some months we will have 4 managers and others we will only have 2 managers.

I have tried using =INDIRECT("'" & G16 & "'!" & G18) that will pull the tab Helper!D2 to get names and that works but I don't know how to make the formula that will work with more or less managers so that I don't have to change 100s of formulas every month.

Tables/Tabs

Table

Manager Name	LTR Remarks	LTR Score
Manager One	Very Helpful.	7
Manager Two	Very Friendly.	8
Manager Three	Excellent Service.	6
Manager Four.	Not Happy.	2

<tbody>
</tbody>

Formula:

   =SUMPRODUCT(--(INDIRECT(H$3   &"[Manager Name]")="Manager One)--(INDIRECT(H$3 &"[Manager Name]")="Manager Two")--(INDIRECT(H$3 &"[Manager Name]")="Manager Three"),--(INDIRECT(H$3 & "[LTR   Score]")<=7),--(LEN(INDIRECT(H$3 & "[LTR   Remarks]"))-LEN(SUBSTITUTE((UPPER(INDIRECT(H$3 & "[LTR   Remarks]"))),UPPER($A22),"")))/LEN($A22))

Tab with Formula:

Neg Remarks	LTR	Rep Sat	Apr_2017 ($M$3)
(Blank)	(Formula from above)
Helpful (A22)
Friendly

<tbody>
</tbody>

Helper Page:

Manager Names

Manager One

Manager Two

Manager Three

Manager Four

<tbody>
</tbody>

 

[StephenCrump]

Duplicate: Dynamic Names in Formula