Copilot in Excel will soon help reference data from various sources such as the web and Word files. It will be able to query the web, reference Word files, and pull data from another Excel file.

This can even be done from one workbook to another. Here’s how to pull data from another data source within Excel.