Repair Golf Tournament Excel Organizer

I already have an Excel file that ChatGPT drafted for my charity golf tournament, but the logic is glitchy. In the “Raw Data” sheet I want to type a player’s name, pick a group number from a drop-down, and have the workbook instantly sort and store that entry... (Budget: $10 - $30 USD, Jobs: Data Analysis, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps)