Excel 2013: Copy Pivot Table Values to New Sheet and Retain Formatting

So I posted earlier about trying to copy pivot table values to a new sheet while retaining the format, and I thought I had it figured out, but I am still having issues getting it to work.

Is there a way to copy an entire sheet, with multiple pivot tables and tables, and retain the formatting but just paste as values? I've attached an example of what I am looking for... sheet1 has an example of the tables, and sheet2 has been manually adjusted to look like the desired output. Ideally I would like to be able to copy and paste values/formatting, but it does not seem to work. If there is a workaround using VBA, that would be fine as well.

Thanks in advance.

example.xlsx

copy the cells then select the destination and click the dialog launcher at the bottom right corner of the clipboard group and then click the item in the clipboard. that will paste values and formats