Export Selected Columns to a New Workbook

I would like to be able to run a macro that exports (moves a copy) a single WorkSheet from a Workbook into a standalone Workbook, but I only want selected columns exported. The exported worksheet needs five things:

1. To have the same worksheet name
2. To have the header row frozen and filter arrows in place automatically
3. For the exported columns to be adjacent to each other
4. All values in the exported worksheet to be Paste Values to avoid any links to the original file
5. All cell formatting to remain in place, so header row colours, conditional formattting etc., i.e. Paste Format

I've attached a simple example, the main sheet shows how the original sheet would look, the second sheet shows how the exported file should look, so in the example, it is only the columns with red headers that should then appear in the exported file.

The main sheet has around 70 columns, but I'm happy to specify these in the code as these may change over time.

Many thanks