Consolidate Sheets while Splitting Rows - Best way to achieve?

[supercharger]

I have two worksheets with data, Communications and Training. Each row contains two date columns, "Approve By" and "Deliver By". I have a third sheet that has an automated calendar that will take a Date, Name, and Details from the fourth sheet - Calendar Items.

What I'm struggling with is how to automate the flow of content from Communications and Data to Calendar Items, while creating a separate row for Approve By and a separate row for Delivery By for each row in the previously mentioned sheets.

I unfortunately don't practice my VBA to be good enough to fend for myself.

Any help is appreciated!

 

[supercharger]

Without being able to share the file here, this is the best way I can summarize it.

Communications Sheet (or something like it):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Channel[/TD]
[TD]Audience[/TD]
[TD]Approved By Date[/TD]
[TD]Deliver By Date[/TD]
[/TR]
[TR]
[TD]Email[/TD]
[TD]Sales[/TD]
[TD]03/01/2018[/TD]
[TD]03/15/2018[/TD]
[/TR]
[TR]
[TD]Town Hall[/TD]
[TD]North America[/TD]
[TD]03/25/2018[/TD]
[TD]04/01/2018[/TD]
[/TR]
</tbody>[/TABLE]

Training Sheet (or something like it):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Course[/TD]
[TD]Audience[/TD]
[TD]Approved By Date[/TD]
[TD]Deliver By Date[/TD]
[/TR]
[TR]
[TD]Office 2016[/TD]
[TD]HR[/TD]
[TD]03/16/2018[/TD]
[TD]03/30/2018[/TD]
[/TR]
[TR]
[TD]Leadership 101[/TD]
[TD]Managers[/TD]
[TD]04/07/2018[/TD]
[TD]04/15/2018[/TD]
[/TR]
</tbody>[/TABLE]

What I would like is to have one sheet from this that would return 8 rows (email approved details, email deliver details, town hall approved details, etc). I have a Calendar that I can map these deliverables on to, but need a separate line item for each.

 

[supercharger]

Bump. Can anyone help?