Splitting up part numbers in to different sheets

Hi

Column 1 contains the part number and column 2 contains the socket codes it will fit into, there are 4 different sockets but over 1000 parts, what I am looking to do is have five sheets one for each socket. Parts are added to the database on a weekly biases.

The socket numbers are; 10, 20, 30, 40 these will each have a separate sheet.

PART 22 can either be used with a 20 socket or 2 number 10 sockets.

Coloumn 1 Sockets
PART 1 10
PART 22 20
PART 36 30
PART 95 40

Can someone help me on how to do this, any help is much appreciated.