If you are copying and pasting the same 60 modules across every project estimate, you are not building estimates. You are fighting a spreadsheet that refuses to scale with you. The real problem here is not a missing function. It is a missing structure. You have already done the hard work: you have identified the repeatable components, you have sized them, you have priced them. What you need now is a system that treats each module as a reusable building block rather than something you have to drag into place by hand.
The functions that will save you are `INDIRECT`, `XLOOKUP`, and a naming convention that lets you call any module by name. If you name each module tab consistently, say "MOD_Concrete," "MOD_Framing," "MOD_Electrical", then `INDIRECT` can pull the total from any module without you ever opening that tab. A master project sheet can list the modules you need for that job, and `XLOOKUP` can fetch the corresponding totals from a reference table that maps each module name to its tab. You build the reference table once, and from that point forward, every project estimate becomes a simple list of module names. No more hunting, no more linking cells by hand, no more copying.
This approach does more than save time. It eliminates the errors that creep in when you manually replicate data. A misclicked cell, a stale total, a missed module, these are not risks you should accept for work you already solved once. By modularizing your estimate this way, you also gain the ability to update a single module and have every project that uses it reflect the change instantly. That is the kind of productivity shift that turns a repetitive grind into a repeatable process.
You are not asking for a magic bullet. You are asking for the right tool for the job you have already designed. `INDIRECT` and `XLOOKUP` are that tool. Set up the naming convention, build the reference table, and test it on your next project. The copy-paste grind ends the moment you decide that your modules deserve a system as structured as the estimates they produce.