Microsoft Excel allows easy importing of data from another workbook through external references. By typing the source workbook name and the sheet from where data is to be pulled, one can create an external reference between workbooks. The command is simply written as follows: "data from: =[SourceWorkbook.xlsx]Sheet1!$A$1". It is important to note that the file extension must be included in the source workbook name.