Database functions

I have a database (excell 2003) with 6 columns that lists details relating to 20 categories and there are numerous entries for each category. I can filter in the worksheet but what I want to do is to to extract the details for some of the categories into a separate worksheet so that I have an instant anlaysis of those categories after I have entered data in the database. I have sort of got it to work by filling the second sheet with lots of 'if' funtions but I seem to recall being able to set a heading and critera and get an extract form a database but I cant find it in any help. any suggestions please?

Thanks I'll give it a go.