Best way to have sheets reverence one sheet

I have a workbook that I use a little like a data base of some products I work with. I made column heading representing different things or values for different products. I have maybe 30 columns each representing a attribute of the products. Each row is a different product and I fill in a cell in the column with its value that relates to that column.

What I want to do is create sheets in my workbook that use this information but trimmed down to create simple sheets with only specific columns on them that will update when the main "master" sheet is updated. Say "Sheet 1" (my master sheet) currently has 170 rows, but this list will only get larger, I just want to be sure this will still count all the information even if I have 200 rows.

I believe what I want to do is create a pivot table, but even that is confusing me, does anyone have any thoughts on the best way to achieve what I am looking for?

Thanks,
Matt

Originally Posted by JBeaucaire

Show us what you're designing and what you want for intended results on a sampling of your main workbook.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

Here is a file that was a start to what I was doing. It is not pretty but you can get the point.

Thanks,
Matt

What I am looking for is the other sheets to populate off of the information on the fist sheet. So when I add a new row they appear and are sorted appropiatly on the other sheets.

Make sense?