VBA to Create New Tables Based on Data

[horrellbt01]

I have a table of data that I would like to split up into multiple tables based on Parent/Child Relationships.

Parent	Child	Item	Order
Joe Smith	Jaden Smith	12345​	5​
Joe Smith	Jaden Smith	54321​	2​
Joe Smith	Emma Smith	54321​	1​
Jane Emmit	Hank Emmit	12345​	5​

Above is a sample table, actual has thousands of rows with many parent/child combinations.

I am looking for a Macro solution to create a new worksheet for each unique Parent with separate tables for that Parent/Child relationship within that worksheet.
So after running I would end up with the following:

New Worksheet "Joe Smith"
New Worksheet "Jane Emmit"

Within Worksheet "Joe Smith"
Table "Jaden Smith"
Table "Emma Smith"
Each table containing all rows for that parent/child combination

Within Worksheet "Jane Emmit"
Table "Hank Emmit"

 

[HighAndWilder]

Is the source data actually in a table and if so what is it called and what is the name of the worksheet that it is on?

In the tables created are they to contain all four columns from the source data?