Before I decided to post this question I did some research on the forum to see if this question has been asked before. I did find a post resembling what I needed but it was not "noob friendly" enough for me to fully grasp what needed to be done to make the code work.
Basically, I have a workbook with 4 sheets. The sheets are labeled as Active, Inactive, Refusal, and Hospice. The main sheet that we work on is the 'Active' sheet. Within this sheet, starting on cell J4 and down, I have a drop down menu where you can choose the the status (labeled the same as the sheet names). What I am looking to do is to have specific information from that row to move to the respectively named sheet whilst simultaneously deleting that entire row from the "Active" sheet.
Any and all help would be greatly appreciated!! Thank you very much in advance for any help!