How to Link Amounts Between Expense and Income Sheets in Excel
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.

- 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.
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.
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.
Open your workbook and click on the cell within the Income and Expense Summary sheet where you want the amount to appear.
Type an equal sign (=) to initiate the formula.
Click on the worksheet tab for your monthly expense sheet at the bottom of the window.
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 the Paste Link Feature
If you need to quickly link multiple cells or ranges without manually typing out formulas or clicking back and forth, you can utilize the Paste Link tool.
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. Open your workbook: Launch WPS Spreadsheet and open your financial tracking workbook.
- 2. Initiate the formula: Click on the target cell in your Summary sheet and type '='.
- 3. Link the data: Switch to your Expense sheet, click the total amount cell, and hit Enter to link them instantly.

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.




