find and Summarize data in a table from a different sheet?

[Richard Z SF]

I have a master sheet that has a table with rows of data. The first 3 columns
of each row contain information that categorizes the rest of the data in the
row. I want to create a summary sheet that looks in this master sheet and
displays only rows of a particular category.

If it helps the data is an export from a bug tracking software and I want to
be able to display on a sheet all the bugs for an individual designer from a
particular area of the product and the detail about the bug. All of this
information is included in each of the table.

Thanks

 

[John C]

Couldn't you just filter the data?

 

[Richard Z SF]

I could but I want summarize it on different sheets in different ways. I
think if I filter the data I have to do it in the table itself and I need to
do it every time I want to look up a new user.