VBA to Create Gantt Chart

Right now I have a summary sheet to track projects through the beginning of the design phase, all the way through construction completion. Attached is an image of the visible columns, it goes all the way out to AJ.

What I cannot figure out how to do is starting in column AK is to start a gantt chart or something similar. I posted a photo of what we currently do manually, but would think it is possible to pull the information from the dates on the summary sheet.

I should note that I am not very good with this and have pieced my workbook together of the past 10 or so years.

Capture2.PNG
Capture.PNG

Images are no use to anyone, you'll need to upload a sample of the actual workbook. See the yellow banner at the top.

Sorry about that!

Attached is the workbook with some test sheets. The code is a bunch of random code I have managed to google/somehow make work over the last 10 or so years.

Project Test Example.xlsm

Anyone????