Monthly Report from Pivot Table.

Hey guys,

I have a pivot table that has several clients, clients numbers and data. This pivot table comes from an external source. The client numbers are the row headers and the type of data is the column header. There are 3 different types. I need to create a new sheet and report from data pulled from pivot table. It will then create a new sheet for each month with the year to date also. In the report I need to save the monthly information and have the previous months for the year on there as well. Also i need the Year to date totals in a separate column on the report. I dont want to Have everymonth on the report just the previous ones. The report will just have the total from the created sheet along with YTD totals along with company info, logo, contact ect. I have attached a test sheet of what I am talking about.