I would love to chat about your project - as I love delivering these kinds of dynamic form challenges in Excel. I have built numerous work request forms like this, using conditional formulas, conditional formatting, and VBA (macros) so the form performs seamlessly.
About me: I am a technical business analyst with 15 years professional experience working with Excel, VBA, Access, and SQL Server to deliver complex reporting, automation, and data processing solutions.