Compiling Two Worksheets in Excel into One and export as CSV

I have a excel reporting tool which generates two sheets, both with equal amount of columns.

My task is to create a third worksheet which is the two sheets combined into one in the following format.

(Sheet 3)
---------------

Sheet 1 (Title)
Name1  Name2  Name3
Data1    Data2     Data3

Sheet 2 (Title)
Name1  Name2  Name3
Data1    Data2     Data3 

Select allOpen in new window

I need to have this automated in VBA, any direction would be grateful.