Submit button Macro not working correctly

[Frankinstyyn]

Hi all you amazing forumers!!

I've attached a spreadsheet in which a request is entered into a certain area.

This should then jump to a specified place in the view data tab that is relevant. For example, if someone chose inputdata>businessimprovement>openedanewaction then pressed submit then this data would go to the tab 'VIEWBusiness Improvement. If possible showing the date, business improvement and opened a new action? I've done it but with 3 separate buttons when I want one.

As there is a lot of data I would like something that I can duplicate with all 17 'Submit' buttons that will be clicked.

Once the submit button is then pressed the from should revert to empty again and, if possible, the user would get a choice to submit a request in the same place or go back to the last tab they were on to chose another team?

Thanks all of you beautiful people, feel free to make changes to the spreadsheet if necessary. I am so grateful to all of you!!! Frank