Macro for perfoming same data manipulation to monthly files to create a report

[newbieexcelgirl]

Hi, I have to create monthly dashboard reporting on this set of data attached in Excel 2010
For me to do this I
1. Copy and paste all the countries data into one spreadsheet.
2. Add a new column to show the different products grouped into one regardless of the version
3.Then link to device type

I then create a pivot table from this and show:

a)Device Type by country and percentages
b) How many days they were offline etc
c) and different data reproting

And then create this into a dashboard.

However I am getting thie file with different months in each tab and doing this manually every months.

Is there a macro where i can run to do the manuipuation and extracting for me every month?

All help is genuially appreciated and regarded highly.

Kind regards,

Newbie