Project Planner..... VBA or formulas? actual workbook included

I started this project as a Gantt chart but then figured out it was a lot of work to populate and update the data if one item changed. So I set out to make the process automated but as I'm getting further along it is getting very large and I'm afraid I'm spending too much time when I could be learning a better way. I have included the actual file with the real data.....none of it is sensitive, its just a bunch of job # with times. There is one part of !JobData that comes from another workbook so I have pasted values but left R1 as the original formula that gets the data for reference. If anybody has any ideas on how to make the process better or faster or less process intensive, please let me know. I'm willing to learn VBA and macros if somebody can point me in the right direction.

Thanks so much

Sorry for the confusion Richard the worksheet "Project Planner" has the Gantt chart and "Job Data" is where I'm trying to get the data to automatically populate based on planned start times and what machine they are assigned to. Hope that helps. Thanks for your time.

Correct that data comes from a separate workbook. I didn't now include it because it is about 10mb. I pasted the values so the data would be there and the edit links dialog box wouldn't interfere.

Sure thing see attached