Insert left most cell in function code

Hi I have a function in a cell that looks like this

Please Login or Register  to view this content.

Instead of having the "Summary!$A$2" I want to index the left most cell in the same row as the cell with this function in it. The above code would be perfect for cell C2 but as I have to sort, then this function becomes useless in a different positoin

Please Help!!!