Originally Posted by macropod

An external reference formula contains the path, filename, sheet name and cell reference of the cell whose value you want to retrieve. Such a formula typically looks like:
='C:\Users\UserName\Documents\[SourceWorkbook.xlsx]Sheet1'!$A$1