How to Show Data from Another Sheet in Excel

Working with data spread across multiple sheets is a normal part of getting things done in Excel. Instead of cramming all your information into one massive, endless grid, you can organize it logically into separate tabs - like Q1 sales, Q2 sales, client lists, and product inventory. This article covers the simple and reliable methods for showing data from one Excel sheet on another, so you can build summary reports and dashboards without endlessly copying and pasting.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Link Data Between Excel Sheets?

Before we get into the "how," let's quickly touch on the "why." Pulling data from another sheet isn't just a clever trick, it's a fundamental practice for good data management. When you link cells and data ranges, you create a dynamic connection. Update the data on the source sheet, and it automatically updates everywhere it's referenced.

This approach helps you:

• Keep Your Data Organized: Separating raw data (like monthly sales transactions) from summary reports (like an annual dashboard) makes your workbook much easier to navigate and understand.
• Create a Single Source of Truth: When everyone is pulling from the same master data sheets, you reduce the risk of different team members working with different, outdated numbers.
• Automate Your Reports: Build a summary dashboard once. As you add new data to your source sheets each week or month, your summary automatically reflects the latest information.
• Avoid Manual Errors: Copying and pasting is a recipe for mistakes. A typo, a missed row, or pasting into the wrong cell can throw off your entire analysis. Linking eliminates this risk.

Method 1: The Easiest Way with a Simple Cell Reference

This is the most straightforward method and perfect for pulling a single value - like a total sales figure or a key metric - from one sheet to another. It involves telling a cell on one sheet to simply display the value of a cell on another sheet.

The syntax for this is wonderfully simple: SheetName!CellAddress

If your sheet name has spaces in it (e.g., 'Q1 Sales'), you'll need to wrap it in single quotes: 'Q1 Sales'!CellAddress

Let's walk through a practical example.

Imagine you have two sheets:

• Q1 Sales: This sheet contains all your sales data for January through March, with a grand total in cell F50.
• Annual Summary: This is your dashboard sheet where you want to display the Q1 total.

Here’s how to pull that total into your summary sheet:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions:

1. Click on the cell in your Annual Summary sheet where you want the Q1 total to appear (let's say it's cell B2).
2. Type the equals sign (=). This tells Excel you're starting a formula.
3. Without typing anything else, use your mouse to click on the Q1 Sales sheet tab at the bottom of your workbook.
4. Now, click on the cell containing the value you want. In our example, you would click on cell F50.
5. Press the Enter key.

Excel will automatically take you back to your Annual Summary sheet. Cell B2 now displays the value from Q1 Sales!F50. If you look in the formula bar, you'll see the reference Excel created for you: 'Q1 Sales'!F50. Now, any time the total sales value in cell F50 on the Q1 sheet changes, cell B2 on your summary sheet will update instantly.

Method 2: Looking Up Specific Data with VLOOKUP and XLOOKUP

What if you don't want a static cell, but need to find a specific piece of information in a table on another sheet? This is where lookup functions come in. You have an ID, a name, or some other unique identifier, and you want Excel to find its matching data in a larger list.

For instance, you might have a sales transaction list with Product IDs, but you want to pull in the full Product Name for your report. The Product Names live on a separate "Products" sheet.

Using VLOOKUP to Find & Display Data

VLOOKUP (Vertical Lookup) is the classic Excel function for this job. It scans down the first column of a table in search of a specific value and then returns a corresponding value from a different column in that same row.

The syntax looks like this:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value: The value you're searching for (e.g., a Product ID in your sales report).
• table_array: The range of data to search within, located on your other sheet.
• col_index_num: The column number within that table from which you want to pull the return value (e.g., column 2 for Product Name).
• range_lookup: Typically set to FALSE for an exact match.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

VLOOKUP Example:

Let's say you have these two sheets:

• Sales Data: Has a ProductID in column A and you want to fill in the ProductName in column B.
• Product List: A master list with ProductID in column A, ProductName in column B, and Price in column C.

On your Sales Data sheet, in cell B2, you would enter this formula:

=VLOOKUP(A2, 'Product List'!A:C, 2, FALSE)

Let's break that down:

• A2: This is the ProductID you're looking for on the Sales Data sheet.
• 'Product List'!A:C: This is the table on the Product List sheet where Excel should look. It starts its search in column A.
• 2: If a match is found in column A, return the value from the 2nd column of the table (which is column B, the ProductName).
• FALSE: This ensures Excel only returns a result if it finds an exact match for the ProductID.

You can then drag this formula down to populate the product names for all your sales entries.

The Modern Alternative: XLOOKUP (Microsoft 365/Excel 2021+)

If you're using a modern version of Excel, XLOOKUP is a far superior and more flexible alternative to VLOOKUP. It’s easier to write and fixes many of VLOOKUP's limitations (like the search column having to be the very first one in the table).

The basic XLOOKUP syntax is:

=XLOOKUP(lookup_value, lookup_array, return_array)

Using the same example as above, the XLOOKUP formula would be:

=XLOOKUP A2, 'Product List'!A:A, 'Product List'!B:B)

This is much more intuitive:

• A2: Look for this Product ID.
• 'Product List'!A:A: Look for it in this column (the lookup array).
• 'Product List'!B:B: When you find it, return the corresponding value from this column (the return array).

XLOOKUP is less prone to errors if you insert or delete columns in your source data, making it a more robust choice for modern spreadsheets.

Method 3: Linking an Entire Range of Data

Sometimes you don't just want one cell or a looked-up value, you want to mirror an entire table or range of data from another sheet. Modern Excel makes this incredibly easy with dynamic arrays.

Let’s say you have a small summary table of your top 5 products on your Q1 Sales sheet in the range G2:H7. You want this exact table to appear on your Annual Summary sheet.

1. Navigate to your Annual Summary sheet and click on the cell where you want the top-left corner of your table to appear (e.g., D2).
2. Type the equals sign (=).
3. Click over to the Q1 Sales sheet.
4. Select the entire range of data you want to display by clicking and dragging from G2 to H7.
5. Press Enter.

Excel will instantly "spill" the data from that range into your Annual Summary sheet. The data in cells D2:E7 on your summary sheet is now directly linked to the source range. Any change you make in Q1 Sales!G2:H7 will be reflected immediately. You only have to write one simple formula - ='Q1 Sales'!G2:H7 - in one cell, and Excel handles the rest.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices and Quick Tips

Linking sheets is powerful, but a few good habits can prevent headaches down the road:

• Use Descriptive Sheet Names: Naming sheets Sheet1, Sheet2, and Sheet3 will make your formulas confusing. Names like Sales_Data_Q1 or Client_Contact_List are much clearer.
• Keep Data Structured: When pulling data from multiple sheets (like quarterly reports), try to keep their layouts consistent. If the "Grand Total" is in cell G50 on one sheet, try to keep it there on all of them.
• Beware of Deleting Things: If you delete a sheet, column, or row that a formula is pointing to, your formulas will return a #REF! error. This means the reference is broken. Be mindful of linked data before making big structural changes.
• Lock References with '$' When Needed: When dragging lookup formulas, you might want to lock your table array so it doesn't shift. You can do this by using dollar signs, like 'Product List'!$A$1:$C$100. This is known as an absolute reference.

Final Thoughts

Learning how to show data from another sheet is an essential Excel skill that transforms your workbook from a static report into a living dashboard. Whether you're using simple cell references for key totals, XLOOKUP for pulling in specific details, or dynamic arrays to mirror entire tables, these techniques help you build organized, automated, and error-free reports.

While mastering formulas is a superpower, we know that spending hours in spreadsheets isn’t always the best use of your time. This is especially true when your data lives across multiple platforms beyond just Excel - like Google Analytics, Shopify, QuickBooks, and your CRM. We built Graphed to solve this very problem by automating the entire data connection and reporting process. Instead of writing formulas to link sheets, you can connect all your data sources with a single click and simply ask questions in plain English, like "Show me my top-performing ad campaigns by revenue last month." Graphed instantly builds a live, interactive dashboard for you, saving you from the manual work of building reports yourself.