If the cell referred to contains text if it isn't empty, you can use a formula such as
='Other Sheet'!C1&""
where Other Sheet is the name of the sheet you want to refer to.
If the cell might contain text or a number, use
=IF('Other Sheet'!C1="","",'Other Sheet'!C1)
