I want to organize my data so that each sheet in my work book is the data for a specific organization, except for my master list. I do not want to copy and paste each row of information onto the other sheet, rather I want it to update every time I open the workbook. I have my table set up as Date, Full Name, Email, Number, Address, Case Status, Referral Agency, Amount Approved. I want the data to auto populate based on which referral agency gave me the client though I have it set up as a dropdown menu. I am in no way a professional Excel user but I know my way around. If there is a video that breaks down the steps, or if anyone knows how to do it and explain it in major detail, thank you so much, it would be greatly appreciated!
][1]
