Is there a way to create a permanent input form in excel to enter data and
have the data recap to a master data sheet.

I need to create an input form so that the users can input in fields without
any issues of which line they are inputting on.

What I need this one to do is if it is a Sale it populates questions that
need to be answered if it is a referral a different set of questions will
appear.

The users do not like access so that is why I need to create this in excel.

thanks