Losing column formatting when copying worksheet to new workbook.

[foolios]

Attempting to do:
I have a macro enabled workbook(.xlsm) with 2 sheets that are filled in by a third sheet.
I want those 2 sheets to be saved as .csv files separately from each other
and the original workbook so that I can upload them to a database.

So far:
Through VBA code I have found that I can't simply save the worksheets but that each sheet has to be moved to a new workbook then saved.
That feature works.

The problem:
The formatting of columns as text and custom to preserve leading zeros
is lost from the original worksheet to the moved to worksheet.

Question:
How do I keep all the column formatting during the sheet's transition to the
new workbook for saving?

Thank you so much in advance!

 

[foolios]

By the way:
I keep reading that sheets have to be moved to a new workbook before they
can be saved but I realized I've been using this code block below all along without issue and
it does basically just that; exports the worksheet directly as a .pdf without being moved to a new workbook.

Why can this be done with .pdf's or is there a way that I haven't read
about to do this with sheets themselves to .csv ???

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
        Filename:="***.pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, _
        IgnorePrintAreas:=False, OpenAfterPublish:=False

Thanks for your time.