How do I reference a cell in another sheet using a value from the active sheet

I want to reference cells in another sheet, I know how to reference them directly but I need to reference them from a value that points to the cell that is in the active sheet.  I know this doesn't ...