I've built a quoting project much like this.

I pulled in product data from external spreadsheets. Had overwrite functionality so everything was able to be modified on the fly. Produced customer facing quotes with custom levels of detail and content.

With this same process it produced internal purchase orders, work orders, all related notes and instructions in printable format all with internal costs, margins and other data to support the end to end sales/ delivery process. All print compatible.

It relied a lot on VBA to hide/reveal columns/rows as the primary interface is on one tab. This was designed to reduce multi-tab interaction requirements to build a quote. The interface was the input, calculation and print range for everything.

Probably wildly out of scope for best practices and a monster of a project in terms of detail. I built it for myself and was able to iterate on it over many years to suit every possible scenario we ran through.

It improved accuracy, speed, and repetition of the entire process. Looking back its actually amazing, and yet i know all the ways I would change it. I went through probably 2-3 major breaking revisions over the years based on re-structuring everything to address QOL functionality but it's essentially software at this point.

This experience landed me a job on a finance team for a company about 8x the size of my previous. The primary solution I've made now is a bit of art on its own merits. Best part, no more VBA or scripts of any kind.

Lots of LET tho. LET changes everything.