# Linking Excel Sheets to a Summary Page: 4 Easy Methods

### Method 1 – Use Consolidate Command to Link Excel Sheets to a Summary Page

Step 1:

• Select the cell After that, from your Data ribbon, go to,

Â Data â†’ Data Tools â†’ Consolidate

• AÂ  Consolidate dialog box will appear in front of you. From the Consolidate dialog box, type â€˜Quarter 1â€™!\$B\$4:\$D\$14 in the ReferenceÂ press Add option.

• Add the rest of the sheet value. Check the Top row, Left column, and Create links to source data like the below screenshot. Press OK.

• You will be able to link Excel sheets to a summary page, which has been given in the screenshot below.

• We will sum up the total revenue earned by the sales representatives using the SUM function like the below screenshot. The return of the SUM function is \$5,270,036.00.

Step 2:

• After linking Excel sheets to a summary page, we will check whether it works or not. Change any value of the source data. We will change the revenue earned by Samuel Jhonson from \$51,371.00 to \$71,371.00.

• We will notice that the total revenue earned is changed from \$5,270,036.00 to \$5,290,036.00 automatically which has been given in the below screenshot.

### Method 2 – Perform Hyperlink Command to Link Excel Sheets to a Summary Page

Step 1:

• Select the cell After that, from your Insert ribbon, go to,

• A Insert Hyperlink dialog box will appear in front of you. From the Insert Hyperlink dialog box, select Place in This Document under the Link to selectÂ â€˜Quarter 1â€™ under the or select a place in this document drop-down list. Press OK.

• You will be able to link the â€˜Quarter 1â€™ sheet with the Summary_Hyperlink sheet in cell B5.

• You can link the rest of the sheets with the Summary_Hyperlink sheet like the screenshot below.

Step 2:

• Click on any of the cells and it will take you to the respected worksheet.

• And our job is done!

### Method 3 – Define Selection Portion to Link Excel Sheets to a Summary Page

Steps:

• Select cells B5 after that, give a name of the selected range, and the name is Group. Press on the left-top box and type that name like the below screenshot.

• Select cell B5 and type the below formula. The formula is,
`=Group`

• Simply press ENTER on your keyboard, and you will get the return of that function with linking.

• After linking Excel sheets to a summary page, we will check whether it works. To do that, change any value of the source data. We will change the revenue earned by Samuel Jhonson from \$51,371.00 to \$61,371.00.

• We will notice that the revenue earned by Samuel Jhonson is changed from \$51,371.00 to \$61,371.00 automatically which has been given in the below screenshot.

### Method 4 – Linking Excel Sheets to a Summary Page Manually

Steps:

• Select cell C5 and type =.

• Go to the â€˜Quarter 1â€™ sheet, and select cell D15.

• Press ENTER on your keyboard, and you can link the â€˜Quarter 1â€™ sheet with the sheet named Summary.

• Linking the sheets â€˜Quarter 2â€™, â€˜Quarter 3â€™, and â€˜Quarter 4â€™ with the sheet named Summary which has been given in the below screenshot.

• We will sum up the total revenue earned by the sales representatives using the SUM function like the below screenshot. The return of the SUM function is \$2,762,760.00.
• To check whether the linking works, repeat step 2 of method 1.

## Things to Remember

âžœ While a value can not found in the referenced cell, the #N/A! error happens in Excel.

âžœ #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.

## Related Articles

<< Go Back To Excel Link Sheets | Linking in ExcelÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF