I'm trying to make a worksheet that allows employees to type in their first &
last name and display corresponding data from other workbooks. I have an
INDEX function that does this well, but what I want is for it to display
results that match all of their logins. I tried to use the OR function but I
can't make it work. See example below:

This function does what I want it to do, for one of their logins:

=INDEX('\\Santbdc\Breakroom\Productivity Reports\[last
day.xls]Output'!$A$3:$S$1000,SMALL(IF('\\Santbdc\Breakroom \Productivity
Reports\[last
day.xls]Output'!$A$3:$A$1000=$T$2,ROW('\\Santbdc\Breakroom \Productivity
Reports\[last day.xls]Output'!$A$3:$A$1000)),ROW(1:1))-2,1)

The problem is that instead of only matching the item in cell T2, I want it
to return all the results that match cells T2, T3, and T4

How can this be done?

P.S. I tried using the OR function like this, but it returns values that
don't match:

=INDEX('\\Santbdc\Breakroom\Productivity Reports\[last
day.xls]Output'!$A$3:$S$1000,SMALL(IF(OR('\\Santbdc\Breakr oom\Productivity
Reports\[last
day.xls]Output'!$A$3:$A$1000=$T$2,'\\Santbdc\Breakroom\Pro ductivity
Reports\[last
day.xls]Output'!$A$3:$A$1000=$T$3,'\\Santbdc\Breakroom\Pro ductivity
Reports\[last
day.xls]Output'!$A$3:$A$1000=$T$4),ROW('\\Santbdc\Breakroo m\Productivity
Reports\[last day.xls]Output'!$A$3:$A$1000)),ROW(1:1))-2,1)