I also would like to make it so when I enter any data in, it automatically copies to sheet2, but I don't want sheet 2 to auto sort column E as sheet1 does.

Can someone help me out with this?