Automatically populate new sheets with subsets of data from master sheet

[winpod]

Hi,
Sorry for the reality that there is probably a post and lots of answers to it that might manage this issue, but I've reviewed a bunch and none apply directly. I spend lots of time in excel and heavily use its formulas but don't have any real experience using its vba or macro capability.

We have a spreadsheet with lots of data on a single sheet. The data on this sheet needs to be broken down and placed into other sheets based on the commonality of data in a certain column. Ideally it would be dynamic so that if we were to add another row on the main sheet then the new row would also show up on the appropriate breakout sheet, but that's not critical - especially if this adds complexity that isn't worth adding. The only thing that is critical is that once the breakout sheets are populated, we be able to dynamically update certain fields on the fly - easy enough to do with a vlookup.

The example data below shows a simplified version of information on the main sheet and the results that we would like to obtain with this data on other sheets in the workbook.

Any help would be appreciated!!!

Data on Sheet1

part number	vendor			
P/N 123	A	DATA-b2	DATA-c2	DATA-d2
P/N 124	B	DATA-b3	DATA-c3	DATA-d3
P/N 125	A	DATA-b4	DATA-c4	DATA-d4
P/N 126	B	DATA-b5	DATA-c5	DATA-d5
P/N 127	C	DATA-b6	DATA-c6	DATA-d6
P/N 128	D	DATA-b7	DATA-c7	DATA-d7
P/N 129	A	DATA-b8	DATA-c8	DATA-d8
P/N 130	B	DATA-b9	DATA-c9	DATA-d9
P/N 131	B	DATA-b10	DATA-c10	DATA-d10
P/N 132	D	DATA-b11	DATA-c11	DATA-d11
P/N 133	C	DATA-b12	DATA-c12	DATA-d12

results to be on sheet2

P/N 123	A	DATA-b2	DATA-c2	DATA-d2
P/N 125	A	DATA-b4	DATA-c4	DATA-d4
P/N 129	A	DATA-b8	DATA-c8	DATA-d8

results to be on sheet3

P/N 124	B	DATA-b3	DATA-c3	DATA-d3
P/N 126	B	DATA-b5	DATA-c5	DATA-d5
P/N 130	B	DATA-b9	DATA-c9	DATA-d9
P/N 131	B	DATA-b10	DATA-c10	DATA-d10

results to be on sheet4

P/N 127	C	DATA-b6	DATA-c6	DATA-d6
P/N 133	C	DATA-b12	DATA-c12	DATA-d12

results to be on sheet4

P/N 128	D	DATA-b7	DATA-c7	DATA-d7
P/N 132	D	DATA-b11	DATA-c11	DATA-d11