Duplicate a sheet onto a new one with customised column names

Hi everyone,

I need to replicate the values of 1 sheet to another. How can I do that?

I've attached the workbook. Let me do a little explanation.

"RAW Data" sheet contains 3 Pivot Tables which are consolidated from a huge amount pool of data.

Before I can send off the file to the customer I need to format the table header in the format that they requested. The format is in the "Formatted Data" sheet.

Thanks in advance.

Regards,
Mar