Problem with Lists

I trying to make a glossary for my Call-Center Study in Alphabetic way ...
Let me tel u that i owe a lot to this forum and all the moderators and all others..
I presently have two tabs i.e A-A ,B-C and one Tab for List and one Tab for Searching for a particular word..

I have defined three Names by Inserting ->Name ->Define..
AATerm--(formula-OFFSET('A-A'!$B$2,0,0,COUNTA('A-A'!$B:$B),1)
However the above formula does not work in the tab search when i select
A-A in the Dropdown-Index as i want the list till the last entry in the Col B in the Tab A-A....

* this formula works for B-C though
BCTerm--(formula- 'B-C'!$B$2:$B$1000 )
but i dont want to use it this way as it limits me to only 999 entries.

INDEX --(formula- List!$B$2:$B$9 )

In the search tab if u check the data validation i have used the Indirect Function to get a different Dropdown depending on the selection in the cell A2 in search tab the formula is (INDIRECT(LEFT(B2,1)&RIGHT(B2,1)&"Term"))

For strange reasons it works for B-C but not for A-A..whats the solution

i have attached the file plz suggest something i have tried everything..