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):

Channel	Audience	Approved By Date	Deliver By Date
Email	Sales	03/01/2018	03/15/2018
Town Hall	North America	03/25/2018	04/01/2018

<tbody>
</tbody>

Training Sheet (or something like it):

Course	Audience	Approved By Date	Deliver By Date
Office 2016	HR	03/16/2018	03/30/2018
Leadership 101	Managers	04/07/2018	04/15/2018

<tbody>
</tbody>

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?