parent-child relationship in a tree diagram using VBA

I am building a organisational structure for a company. However, my current VBA script does not have a parent-child relationship eg(Trainer under Team Leader). How can i create the relationship in macro and display it in the organisational structure? In the picture below, Jodan and Sky are supposed to be under Jane. I have not created a parent column yet but i have no idea how to go about writing the code to link the child(Jodan and Sky) to the parent(Jane) so that they appear below Jane instead of below Kite. Thank you for your help!
This is my VBA code:

Please Login or Register  to view this content.

structure.PNG

Hello ruiru & Welcome to the Forum,

Give this a try. On Sheet2, you need to have the org in the hierarchal structure which may mean you need to adjust Sheet1. Anyway, on Sheet2 in column C, this is where you are going to put the reports to.

Updated post #2

In column B, apply the colors you want.