Help & Advice: I need to make an excel spreadsheet linked to a form that randomly selects ~11 responses/rows & moves those responses to a different tab

I am working for a free healthcare clinic, and I desperately need help with excel. For our clinic, interested patients fill out a microsoft form, and then they are randomly selected to be seen by us in the excel spreadsheet linked to the form. However, I have no experience in making this happen in excel. I am working with someone familiar with excel to make this happen, but I wanted to ask this here in case anyone has specific experience and advice in these areas.

Ideally, I need:

• To get a list of 11 random patients/rows/responses from the patient lottery responses
• To then move those responses off this tab to a “Selected Patients” tab
• To be able to delete responses every 6 months
• To automatically delete duplicate responses (likely using duplicate phone numbers)

Any help is appreciated - links, tips, etc. Thank you so much.