Excel 2007 : Need a formula to summarize workbook tabs

I'm trying to build a summary worksheet (titled "summary") for a workbook with multiple tabs (named "SchoolA," "SchoolB," etc). The summary worksheet lists the workbook tabs in column A.

I'd like to return "1," "2," "3," or "4" on the summary worksheet if on tab "SchoolA," cells D18 through G18 have an X, with the X denoting the position, i.e. 1, 2, 3, or 4 (I think this is what the Match function can do for me). I've trying putting together an indirect and a match formula but I can't get it to work, e.g. I’ve tried =INDIRECT($A6&(MATCH("X",D18:G18,0))), where A6 is my school tab name but the formula won’t actually look at that tab. I can get the indirect part to work (if I just need to return the value of one cell) and the match part to work (but only if I’m on the school worksheet and not the summary).

I'm bummed that I've spent so much time trying to figure this out and I'd appreciate any help!

Thanks for the tip!

I'd like a formula in B6 on the Summary sheet to refer to the second sheet (“1FLIII.5.1” ). From there I should be able to modify for everything else that I’d like to do. I’d like B6 on the first sheet to analyze D18 through G18 on the next sheet. My understanding of the Match function is that the formula would look at D18 through G18 and return “3” because there is an X in the 3rd cell of that sequence (F18). (BTW, the summary sheet will show you that the full workbook that I’m trying to get this to work in has over 20 tabs. Also, the datasheet might give you a sense of how many times I’ll need to replicate the formula, looking at other sets, e.g. H18 to K18, etc.)