Function Problems

How to Link Amounts Between Expense and Income Sheets in Excel

Bushra ParveenBushra Parveen Nov 10, 2026 868 views

Question details

The user needs an Excel formula to retrieve specific amount data from a monthly expense worksheet and display it on an overall income and expense summary sheet.

How to Link Amounts Between Expense and Income Sheets in Excel
Product
Excel
Device & OS
not provided
Scenario
Creating an income and expense summary that automatically pulls and updates data from individual monthly expense sheets.
Observed behavior
The user wants to establish a dynamic link between worksheets so that updating the expense sheet automatically reflects the new totals on the summary sheet.
Before you start

Ensure both your monthly expense worksheet and your summary worksheet are contained within the same workbook before creating the cross-sheet reference to avoid broken links.

Solution 1Recommended

Use Direct Cross-Sheet Cell References

The most straightforward method to link data between sheets is by using a simple reference formula containing the sheet name and the specific cell address.

By directly referencing the source cell, any changes made to your monthly expenses will instantly update your master summary sheet.

1
Select the destination cell

Open your workbook and click on the cell within the Income and Expense Summary sheet where you want the amount to appear.

2
Start the formula

Type an equal sign (=) to initiate the formula.

3
Reference the source sheet

Click on the worksheet tab for your monthly expense sheet at the bottom of the window.

4
Select the source cell

Click the specific cell containing the amount you want to link, then press the Enter key. The formula will look something like `='Expense Sheet'!A1`.

Use Direct Cross-Sheet Cell References
Syntax Rule: If your worksheet name contains spaces, Excel automatically wraps the sheet name in single quotes within the formula, such as `='Income vs Expenditure'!A1`.
Manage Finances Easily with WPS Spreadsheet

Link Data Across Sheets Smoothly in WPS Office

WPS Spreadsheet makes it incredibly easy to manage personal or business finances by linking data across multiple worksheets seamlessly. It supports all standard spreadsheet formulas and allows for quick cross-sheet references.

  1. 1. Open your workbook: Launch WPS Spreadsheet and open your financial tracking workbook.
  2. 2. Initiate the formula: Click on the target cell in your Summary sheet and type '='.
  3. 3. Link the data: Switch to your Expense sheet, click the total amount cell, and hit Enter to link them instantly.
Fully compatible with Microsoft Excel (.xlsx) formats and cross-sheet formulas.Intuitive point-and-click interface for creating references without syntax errors.Free, lightweight, and fast to open complex financial workbooks.
QA img-9

Frequently Asked Questions

How do I link cells between completely different workbooks?

You can link between separate workbooks by keeping both files open. In the destination workbook, type '=', then switch to the source workbook window and click the desired cell. Press Enter. The resulting formula will include the file name in brackets, like `=[Expenses.xlsx]Sheet1!A1`.

Why am I getting a #REF! error when linking my expense sheets?

A #REF! error usually means the source sheet or cell has been deleted or moved in a way that breaks the reference. Check if the original monthly expense sheet still exists and verify that rows or columns weren't deleted.

Can I sum the same cell across multiple monthly sheets at once?

Yes, you can use a 3D reference. If you have sheets named Jan through Dec, you can type `=SUM('Jan:Dec'!B10)` to add the values of cell B10 from all twelve sheets simultaneously.

How do I automatically pull the total without knowing the exact cell address?

If the location of the total amount changes, you can use lookup functions like VLOOKUP, XLOOKUP, or SUMIFS to search for specific labels (e.g., "Total Expenses") in your expense sheet and dynamically return the corresponding amount.