Filtering database information from one sheet to another

For work we use a database on Excel that gets updated every day with the day's figures (it includes date, customer name, purchase price, and other descriptive columns that I often have to filter and print out to create reports). I am looking for a way to filter the information on the main sheet onto a different sheet automatically as the main sheet changes every day.

FOR EXAMPLE: I want to create another sheet called "RED" and as I add more customers with the code "RED" I would like for the Date, Name, and Total to copy over to the sheet.

Is there a way to do this with Excel? If not, any ideas on how to achieve this?
excel.jpg

You can do this with a couple of formulae. Attach a sample Excel workbook (can't do much with a picture) and I can show you how.

Pete