Structured Reference to Specific Cell in Table

I am trying to reference a specific cell in a table from either a separate cell in the same table or a separate sheet in the same workbook, but not from the same row. For example, using the (slightly...