Form entry and data separation to queues (separate worksheets)

Hello fellow folks,

Rather than implementing a full suite ticketing/ordering system, I'm looking into Excel as a potential solution that's relatively simple for users to input order requests.

We have three departments a user may order from and could add more in the future. I'd like to create a form that all users can use to input their orders and depending on the department that should be fulfilling the request, the data would fill into a queue with a different tab for each department. Essentially it would be one tab for the form and data (hidden data), one work queue from data input into tab two, one work queue for tab two, one for tab three, and so on if expanding.

Is this even possible or does it get too far into macros/VB to be worth it?

Hi,

I don't think Excel is the appropriate application, in particular for multi-users, it's better to use a database software.
It may be acceptable under Excel if each user works sharing nothing with others users,
or only one at a time working on the workbook …