Filter Top 3 and display them in another Sheet

[IgnBan]

Hi everybody, been surfing the net for Forum answers for this frequency filter with no luck. This is what I got; Sheet with all the daily sales of a product metal figurines. This sales data is input daily and listed in a sheet with this description (headers) Date, Product, Color, Size, Price, and Salesman. What I want to do is filter in another sheet in same workbook the best top 3 sold as they are enter, base in the 4 firsts headers ( Date, Product, Color, Size) for the Daily Top 3, and 2nd, 3rd and 4th (Product, Color, Size) for the Weekly Top 3. Is it possible to make it filter as the data is input? Say every 10 minutes? What is the best approach an expression or VBA?
Attached a sample workbook.

Any input is greatly appreciated.:thumb

[IgnBan]

Moderator can you please move this post to the Excel Forum, I posted by mistake here.

Thanks