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.
On Workshop Orders, D6 already uses =SUM(D3:D5) to total three amounts (45, 80, and 65), displaying $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.
='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.
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.
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.
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.
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.
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.