How to Reference a Cell on Another Sheet in Excel

Open an Excel workbook (.xlsx) in Cue Office. Type an equals sign in the summary cell. While editing the formula, switch to the source sheet, select the cell you want to reference, and press Enter. In this example, the order subtotal on one sheet updates the overview on another.

How do you reference D6 on another sheet?

Open the community repair orders workbook. On the Overview sheet, locate B3, which is used to display the order subtotal.

Target cell B3 on the Overview summary sheet is still empty
Display the order subtotal in B3 on Overview.

On Workshop Orders, D6 already uses =SUM(D3:D5) to total three amounts (45, 80, and 65), displaying $190.00.

Three orders on Workshop Orders and the $190.00 subtotal in D6
Source cell D6 already totals three orders for a sum of $190.00.

Return to Overview and type = in B3. While the cell is still in edit mode, click the Workshop Orders tab at the bottom, then click D6. The formula bar shows the reference below.

Formula bar showing the cross-sheet formula with single quotes after switching to the source sheet and clicking D6
Clicking D6 brings the worksheet name and cell address into the formula bar.
='Workshop Orders'!D6

The sheet name Workshop Orders contains a space, so the formula encloses it in single quotes. The exclamation point separates the sheet name from D6. Press Enter to confirm. The source sheet stays open. Click Overview again and select B3 to check the formula and $190.00.

Returning to Overview after committing shows $190.00 in B3 and the cross-sheet address in the formula bar
After returning to Overview, B3 displays $190.00.

Does the overview update when an order amount changes?

Choose File → Save As… to keep a manual copy. Make another copy for testing and change D3 on Workshop Orders from 45 to 55. Check that the subtotal in D6 is $200.00. Return to Overview to see the same amount in B3.

Save this verification file, then close and reopen it. Check B3 for $200.00 and review the formula bar. The next time an order amount needs correcting, simply edit the corresponding order row on the source sheet to update the summary.

Reopening the manual verification copy still shows $200.00 in B3 and the cross-sheet formula
Reopening the updated verification file confirms that the summary still displays $200.00.

How do you ask Cue AI to fill only B3 on Overview?

Open a copy of the original workbook where B3 on Overview is not yet filled, then click Cue AI on the toolbar. When writing your prompt, clearly specify the source sheet, subtotal cell, and target cell, and request that the summary update dynamically with order amount changes.

Could you link the workshop orders subtotal from D6 on Workshop Orders into B3 on Overview, so it updates there when order amounts change? Please change only that cell and leave the existing order records and subtotal alone.
Cue AI toolbar button with the open Cue AI pane below it
Open the larger image to see the cross-sheet reference in the B3 formula bar after Cue AI writes it.

After the formula is inserted, use File → Save As… to save an AI copy, then close and reopen it. Select B3 on Overview, and verify $190.00 alongside the cross-sheet reference in the formula bar.

Reopening the saved AI copy shows $190.00 in B3 and the cross-sheet reference in the formula bar
After reopening the saved copy, B3 displays $190.00 and the formula bar still shows the cross-sheet reference.

Temporarily change D3 on Workshop Orders to 60, then check whether B3 on Overview updates to $205.00. Discard this test change upon closing so the saved copy preserves the original orders and subtotal.

After testing a source amount change, the linked result in B3 updates to $205.00
Temporarily changing 45 to 60 on the source sheet updates the Overview subtotal to $205.00.

Practice with repair orders and a summary sheet

Show the full example

Create two worksheets. The first line of each group below is the sheet name. Enter the remaining lines starting at A1 on that sheet. Enter the order amounts as numbers and leave B3 on Overview empty for the reference. Return to the reference steps.

Overview
Community repair overview
Metric	Amount
Workshop orders subtotal

Workshop Orders
Repair orders
Order	Item	Status	Amount
W-104	Kettle	Complete	45
W-105	Floor lamp	Complete	80
W-106	Desk fan	Complete	65
Subtotal			=SUM(D3:D5)

Verify updated totals before handing off orders

If you make an overview for another repair station, give Cue AI the source sheet name and subtotal cell to create the same kind of link. Before handing over this workbook, ask the colleague who keeps the order records to confirm the kettle amount. Check that the overview matches the orders subtotal so the incoming shift gets the latest figure.

Keep individual amounts in the Excel order book (.xlsx) in Cue Office and write the corrected order number in the Word handover (.docx). Compare the kettle, floor lamp, and desk fan entries with the original repair orders (.pdf). Show the incoming shift the repair subtotal in the PowerPoint briefing (.pptx). Spreadsheets, documents, and presentations are free to edit, and PDFs are free to read.

Download Cue Office for free