How to Fill Cell References From Multiple Worksheets in Excel?
Tags: kutoolsexceltutorial, stepstofillcellrefer, kutools
Published: 2020-10-12 12:03:44

---
title: How to Fill Cell References From Multiple Worksheets in Excel?
published: true
date: 2020-10-12 11:22:30 UTC
tags: KutoolsExcelTutorial,StepstoFillCellRefer,Kutools
canonical_url: https://geekexcel.com/how-to-fill-cell-references-from-multiple-worksheets-in-excel/
---

In this tutorial, we will guide you to learn the steps to **Fill Cell References From Multiple Worksheets in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Dynamically Refer to Worksheets:

- If you have a workbook with two or more worksheets that contain some data and the total price. If you want to extract the total price from each worksheet and display in the master sheet as shown in the below image.

![Example sheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/EXCEL_RNWBuYmyc0.png)<figcaption id="caption-attachment-15625">Example sheets</figcaption>

- In the above screenshot, you can see the **Books** sheet which contains the **total price** of all books in the **cell B7** , likewise, the **Toys** and **Items** worksheets have the total price in the **cell B7**.
- We are going to display the total prices of all other sheets ( **Books, Toys, Items** ) in the **Master worksheet.**
- Kindly, do as below steps.
- On the Master worksheet, you need to click on the cell which represents the reference you will extract across other sheets.
- Then, on the **Kutools Tab,** you need to **click** the **More** option, **choose** the **Dynamically Refer to Worksheets** option from the menu.

![Master Worksheet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Master-Worksheet.png)<figcaption id="caption-attachment-15591">Master Worksheet</figcaption>

- It will open the **Fill Worksheets References dialog box.**
- **Fill order –** In this drop-down box, you need to **select** the **Fill vertically cell after cell** option.
- Then, you need to **click** the **lock icon** near to the **Fill formula** option. Now, you can see the Grey lock icon turns to yellow which means that the Fill Formula is locked.
- You can see the cell reference that you specified in the very first step is displayed in the Fill formula box.
- Then, you need to **click a cell** in the Master worksheet to **display the first extracted value**.
- Finally, **click** the **Fill Range** button.

![Fill Worksheets References dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Fill-Worksheets-References-Dialog-Box-1.png)<figcaption id="caption-attachment-15594">Fill Worksheets References dialog box</figcaption>

- Now, the **values in the cell B7 of each worksheet** are **listed in the Master worksheet**. You need to close the Fill Worksheets References dialog box.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-26.png)<figcaption id="caption-attachment-15595">Output</figcaption>

You can also display the cell references horizontally, to do that you need to **choose** the “ **Fill horizontally cell after cell** ” option from the **Fill order** in the dialog box.

## Sum-Up:

In the above article, you can clearly understand the steps to **Fill Cell References From Multiple Worksheets in Excel Office 365** using **Kutools.** Share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [Protect Multiple Worksheets at a Time](https://geekexcel.com/protect-multiple-worksheets-at-a-time-in-excel-office-365/)
- [Insert Multiple Option Buttons at Once](https://geekexcel.com/insert-multiple-option-buttons-at-once-in-excel-office-365/)