Compare latest 2 months of data

Hi Everyone,

I'm trying to create an automated report, but I'm having many difficulties. Any help would be greatly appreciated.

Essentially I have a "Data" Sheet that I pull the data from to go to the “client” sheets. New data will be continuously added every month to the “Data” sheet.

I want to create tables that compare the last month’s performance to the previous month’s with the percentage of change on the “Client” sheets. I'm currently trying to use the vlookup function to do this but I am incapable of accomplishing it.

Each month the “client” sheets will be exported as a PDF.

Any help with making this possible would be greatly appreciated.
Monthly Reporting.xlsx

Thank you, Unfortunetly that isn't enough.

I've updated the sheet to help you understand more what I need.

It needs to show The last month data, and the percentage of change of the month before. So in this case, it needs to show August's data and compare the percentage of change to july. ex. for client 1, July had 10 phone calls, which is a 23% increase from the month earlier (june).

If you look at the "Client 1" sheet you will see what I mean.

Thanks so much
Monthly Reporting.xlsx

Thank you,

Unfortunately I need to show only one months data compared to previous. It needs to be a simple report. You will see what I need on Sheet "Client 1"

Here is an example

Screen Shot 2014-09-05 at 15.58.16.png