How to pull data from another sheet in Excel

You've got data in one spreadsheet, and you want to use it in another. You could copy it—but then you'd have to manually update the data in each spreadsheet every time the data changed. Who has that kind of time? Not to mention the risk you run of manually inputting incorrect data.

There's a better option: link your spreadsheet cells to keep the data consistent across sheets.

Here's how to pull data from another sheet or workbook in Excel. 

Table of contents: 

• How to pull data from another sheet in Excel 

• How to pull data from another workbook in Excel

• Automate Excel with Zapier

How to pull data from another sheet in Excel

To pull data from one spreadsheet in Excel to another, you need to input the source sheet's name and the name of the cell being copied into the destination cell.

1. Open the Excel workbook with the data you want to copy.

2. Open the spreadsheet that you want to pull the data into. 

3. Click the destination cell (the cell that you want to pull the data into). 

4. Enter = immediately followed by [the name of your source sheet]![the name of the cell being copied]. For example, to copy the value in cell A2 of the "Roster" spreadsheet into the corresponding cell of the "Names" spreadsheet, I'd enter  =Roster!A2. 

5. Press Enter. 

Here's an even easier way to input the source sheet and cell name into your formula: 

1. Enter = in the destination cell.

2. Toggle to the source sheet. 

3. Click the cell you want to copy. 

4. Press Enter, and Excel will populate the name of the spreadsheet and the cell with the value you want to copy into your formula. 

Whichever method you use, Excel will automatically populate your destination cell with the same data as the source cell. Now, if you change the data in the source cell that was copied, the data will automatically update in every spreadsheet where that cell is referenced.

Need to calculate values using the data in your source cell? Simply type the rest of your function as normal. For example, if Names!B3 contains the value 3, and you type =Names!B3*3, Excel will output 9 in your new cell, just as you'd expect.

How to pull data from another workbook in Excel

You can pull data from an entirely different workbook in Excel using the same method as above. But there are a few caveats: 

1. You can only link data from another workbook in the Windows or web version of Excel—not Mac. 

2. If you're using Excel online, both workbooks must be saved in the same online location—for example, OneDrive—and those files must be accessible using the same Microsoft 365 account. 

Here's how to link data from another workbook in Excel. 

1. Open both Excel workbooks. 

2. Enter = in the destination cell. 

3. Toggle to the source workbook. 

4. Click the cell you want to copy. 

5. Press Enter.

That's it. Similar to pulling data from another spreadsheet, Excel will automatically populate the name of the workbook, spreadsheet, and reference cell in your formula.

It's worth noting that you need to open both workbooks whenever you make a change to the source cell—otherwise, changes made to the source cell won't appear in the destination cell.

Automate Excel with Zapier

Formulas can help move data between sheets, but as your dataset grows—or as more teams rely on it—manual work becomes harder to scale and easier to break.

With Zapier's Microsoft Excel integration, you can orchestrate how Excel data flows across thousands of apps. For example, when your team receives a support request via email, Zapier can populate key details from that request in the relevant spreadsheet, use AI to summarize the request and flag ones that meet a certain criteria, and then send that summary to your support team in Microsoft Teams.

Learn more about how to automate Excel, or get started with one of these pre-made templates.

Related reading: 

• How to fix common errors in Excel

• How to enter a formula without a function in Excel

• How to use VLOOKUP in Google Sheets

• How to use IMPORTRANGE in Google Sheets

• How to make an Excel waterfall chart (+ template)

This article was originally published in December 2022 by Matthew Guay. The most recent update was in August 2025.