Extremely slow workbook and complex formulas

Your posted file has LOTS of named ranges...Many refer to entire columns. It also employs SUMPRODUCT against those huge ranges, just to return one value. It's no surprise that the workbook is so sluggish.

I would have taken a completely different approach, using Excel Tables, structured table references, INDEX/MATCH combinations, and helper columns.
I attached an edited version of your workbook that uses those methods and seems to be very responsive.
QUOTETEMPLATEMACRO_RON_v1a.xlsm

Is that something you can work with and expand to suit your needs?
(Let us know if you have questions about that approach.)

Nevermind I understand now. Problem is, the supplier quote sheet is sent to suppliers, so I have to hide the helper column. Works great otherwise! Thank you!

It is displaying 0's where I need blanks, though. That will confuse the supplier. How do I make them blank?

1) You could hide the helper column
- The reason I used the helper column is: most of the other formulas use an INDEX function. The helper cells calculate the RowRef for the INDEX function one time...instead of once per formula.

2) If you use a custom number format, you can hide zero results:
• Select the range to be formatted
• CTRL+1...Number tab
...Category: Custom
...Type: 0;-0;"";@
...Click: OK

Does that help?

(There are many other efficiencies you could include in your workbook, but I tried to just hit some of the worst offenders.)

Custom formats have 4 standard sections:
Pos_nums; Neg_nums; Zeros; Text

This one: 0;-0;"";@
indicates:
If Postitive: Display all digits before the decimal
If Negative: Display a minus sign and all digits before the decimal
If Zero: Display empty text
If Text: Display the text