title should be dynamic sort on adding rows. Would like some sort of worksheet change event code.

I think I have found this on here before but its been years.

I will be adding rows to a workbook each week. I need them to automatically sort on columns A,C and D. Columns C and D have dates in them so I need to keep them in date order.

total columns are A-E. It might have been Zack who helped me with this when he was still on frequently around 2004. I cant seem to locate anything close to what I want.