Try something like:

=INDIRECT(A10&"!A1")

Where cell A10 contains the selected value from the combobox, and A1 is the cell from which you want to get the value.


Mangesh