worksheets that will load data from another worksheet

[foreverandcounting]

I want to be able to create a data base that will be set up to automatically load a worksheet depending on how I catagorized something.
In short. I want to create a master list that will contain information in one column. another colum on that master list will contain a number that I will use to catagorize the information. then I want to set up a work sheet for each catagory. What I ultimately want is these individual worksheest to automatically load the information on to them depending on their category. So, If the phrase "it's a horse a piece" was on the master worksheet and categorized as company #1, I want it (and howerver many others are categorized as company #1) to automatically load on to the company #1 worksheet that i have set up. I know this is a complicated formula but I really need some help figuring it out. Can anyone help?
foreverandcounting@hotmail.com