On Receipts, enter 35, 55 and 20 in B2:B4. The summary formula can use a name that tells the next editor what is being added.
Give the source cells a workbook-wide name
Select B2:B4 in Ulet and choose Formulas → Define Name. Enter WorkshopReceipts, use Workbook scope, and check =Receipts!$B$2:$B$4 before choosing Add. In the summary use =SUM(WorkshopReceipts). Expect 110.

Illustrated range definition with workbook scope.
Inspect the definition after adding a row
Enter 15 in B5. If the definition still ends at B4, the total remains 110. Use Formulas → Name Manager to check the actual boundary and include B5 if it belongs. Reopen and verify 125 with the intended address.

Illustrated boundary check in Name Manager.



