7 files, 30 sheets, One summarry

[Fresh]

Hi there

This is a long one. Hope someone can help!

I receive, on email & on a monthly basis, excel files from
7 countries. Each file has about 5-6 sheets for different
sites in each country and a summarry sheet for the country.
The data in the sheets is the same, i.e sales & volumes
per site. The only way I can get the data is by email - we
do not share a network + there is no one database I can
extract the data from.

Now each month I must consolidate this into one summary
for the region (the 7 countries)and be able to present
summary info(charts) for each country and/or for each site
in a country. I'm currently using a lot of links, macros
and Pivot Tables to analyse and present the data.
I spend a lot of time checking and cleaning the data
before I can anylyse and present information from the data.

Is there a way I can use excel or any other pgm to
automate this process, enure data accuracy + have more
time to analyse the data than gather it. Would this
require a lot of skill like programming etc?

Any help would be appreciated
Regards
Fresh

Any help / references would be appreciated

 

[Ron de Bruin]

Hi Fresh

Start here
http://www.rondebruin.nl/tips.htm