I realize that there are other ways to achieve the results I'm looking for
but I don't have time to learn anything else. I tried to have one workbook
the first "section" you entered customer information and work that needed to
be done by floor than room, the next "section" and the numbers were enter by
links from the first "section" security system layouts, than telephone,
cable and networking than audio and home theater, than intercom and central
vac. These were link to a worksheet with quotes and finally one "section"
for work orders. This thing is huge and hard to manage so I was thinking
about using separate workbooks for each section but that means that I would
have to rename 6 workbooks for each quote and that ridiculous. Is there an
easy way to do what I want to accomplish?

Marc