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