Concatif across Multiple Sheets

[fhill]

*sigh* Back at it.

This time I need to be able to concatenate Multiple cells from multiple sheets using a vlookup. I have already incorporated Mike Rickson's UDF (http://www.excelforum.com/2593269-post9.html) and have tweeked the formula TRYING to do an indirect lookup:

=(concatif(INDIRECT("'"&$BO$2:$BO$6&"'!$a$2:$a$200"),$A2,INDIRECT("'"&$BO$2:$BO$6&"'!$af$1"),"/",FALSE))

Where BO2:BO6 is my sheet range, a2:a200 is where the unique ID for the lookup is located, A2 is the singular lookup key, and AF1 on each sheet is the return information.

Currently the formula returns the very first sheet name if the IDs match, but none others, or absolutely nothing if there isn't a match.

What I am needing is the return (for Example the first person, Rocky Ackerman) on the eemaster in Companies:

Architectural Glazing Solutions/A-1Glass Co Inc

Thanks!