=INDIRECT("'"&K$4&"'!"& INDIRECT("'"&K$2&"'!"&"R2"&14):INDIRECT("'"&K$2&"'!"&"S2"&14))
Cell k4 contains sheet name 1
Cell K2 contains sheet name 2
Cells r2 and s2 in sheet name 2 contain letters representing column references, for row 14
I can get the two indirect functions to work...