From another sheet, the format is:

=SUM('Sheet2'!B46) Where Sheet2 = you actual sheet name and B46=the cell
you want a copy of.

From another file, include the path prior to the sheet name.