Next Button to another worksheet

[Rascal1]

I want to be able to hit a NEXT button on my Excel sheet that will take me to another sheet depending upon the results in cell X.

I.e. if the answer to a question on the sheet is ‘A’ then when I hit NEXTbutton I want to go to ‘sheet INT17’. If the answer is ‘B’ then when I hit NEXTbutton I want to go to ‘sheet INT28’ etc.

It would also be very useful if I could go to a particular sheet when hitting the NEXT button based upon the answer to two questions.
I.e. if I answer ‘YES’ to one question and ‘C’ to another than on hitting a NEXT button I go to ‘sheet ROB3’ whereas if I answer ‘No’ to one question and ‘C’ to another I go to ‘sheet ROB6’.

Can anyone help please?

[carddards]

You could do that using an if else loop, I don't think there is a need for a next button.
If you could provide the specific details or better off a sample workbook, I'm sure we would be able to give you the best advice.

[Rascal1]

Thanks for the offer of help.

File attached.

It for an easy to use budget. The idea is that the user will answer a few questions and then depending upon those answers- when then hit Next will be directed to another sheet of appropriate questions and so on. This way they will only see a few questions at a time and will only have to see relevent questions.

Really appreciate your help