Automatic Autofilter

I have two sheets; Sheet 1 includes all input information and sheet 2 takes that information and spreads it out over a 30 day month...there are many empty cells and rows. The Autofilter reduced the number of "blank" cells and it works great, but when ever the input information is changeed the autofilter has to be updated...is there a way to automate this so that the autofilter is automatically updated whenever new information is input?

The code seems to be working fine. Thanky you!