Is there anyway to make autofilter run automatically?

I want a spreadsheet that shows all data on one worksheet and a second
worksheet that has filters information fed from the first worksheet.

Unfortunately, when I add new information to the first worksheet it does not
appear on the second worksheet until I veiw all records and run the filter
again.

Is there anyway to automate this?

--
Lori