Auto Filter and how to have it auto update

Hello, I hope you can help me. I have a workbook that has many worksheets, one worksheet I'll call it SOLD is pulling needed information from the other worksheets. In the SOLD worksheet I have a column for the date sold and this worksheet using the auto filter. I want it to only show those non-blank rows and update automatically when I update information from the other worksheets. The information on all the sheets are updated all day long but when I go to the sold sheet it isn't updating using this filter and therefore hides the information unless I select the auto filter button, then select all, then select non-blanks again. Is there a way to have it auto apply and show the new information without having to go through this because I just plain forget at times to go the extra steps?

Thank you, hope this will help me and others.
Diva

will you provide us a sample file.........

Regards
CA Mahaveer Somani

I have attached the same file.

What i need to happen is for the completed order tab to only show the orders with turn up dates from the order detail tab automatically. Not all the order detail is to show on the completed order tab and it is laid out differently as well. If this last part is an issue with doing this I can use the same layout on both and just hide the columns not needed.

I appreciate any help you can give.

Thank you

extreamly sorry i could not understand,

what is your exact need..........

will you more elloborate your query please........?


so that i can help you quickly

Regards
CA Mahaveer Somani