I am trying to get something to work and having a hard time any help is
appreciated.

I want to type a "tab" name in cell "A1", then in cell "B2" I want to return
the value in the "tab" specified for the cell specified. For example active
cell "A1" reads "tab" "sheet2", and in in cell "B2" returns the data (nember)
from sheet2 cell "K2" Below I think is a start:

=ActiveCell.Range(A1),value2,"K2"

but get an error when I put this into the cell?? any suggestions...