How do pull unique values from a column to create separate tabs?

[Sandpaperhead]

Hello Everyone,

I'm new to the forum and I was hoping you could help me.

I have an issue where I'm being asked to sort a 10,000 row sheet and create tabs based on what is in row B and what is in Row C.

Essentially here's a sample of the data I have:

(Tab 1) Sorted by "Sent"
Name Date Sent Received
Randy 4/30/2005 Chocolate toys
Shelly 9/5/2007 Chocolate Toys
Donny 6/5/2007 Chocolate Toys
Billy 9/22/2004 Games toys
Timmy 9/22/2004 Games guns
Jerry 8/11/2010 Guns Guns
Bobby 6/27/2007 Guns toys
Sarah 7/26/1988 Toys chocolate
Sandy 6/28/2021 Toys guns

(tab 2) Sorted by "Received"


Name Date Sent Received
Sarah 7/26/1988 Toys chocolate
Randy 4/30/2005 Chocolate Chocolate
Shelly 9/5/2007 Chocolate Chocolate
Timmy 9/22/2004 Games guns
Jerry 8/11/2010 Guns Guns
Sandy 6/28/2010 Toys guns
Donny 6/5/2007 Chocolate Toys
Billy 9/22/2004 Games toys
Bobby 6/27/2007 Guns toys


And based on this data I have to create tabs for "chocolate", "Games", "Guns", "Toys", etc...

as they fall on both sent and received.

The problem is that I'm looking at something with 10,000 rows and I simply copy pasting and creating new tabs will take me 24 hours of manhours, at least.

Please help!

Thank you

 

[Sandpaperhead]

Please help!