A smaller VBA assignment (Excel 2007)

I'm pretty good at programming VBA myself but I'm working on some other stuff. - For a guy with VBA experience this should be an easy job! I have to present this code for some co-workers about programming in VBA. Therefore the code must be very flexible and fast, and the use of functions and variables etc. has to be chosen wisely. Code must serve its purpose, but it's the way the code is written that is important. The job: Main part Make a new excel file and work with data from other files that contains both currency (month) for each year in ten years & clientdata in different exel files for the same time of period. You will have to make all data connect together and find the total sum of sales (calculated after the correct currentcy) for each year, for a given currency. Features in the code: - Write a inputbox that contains the ten biggest clients when writing a correct year as input in a new sheet. - Write a inputbox that contains a graf (circle) of how much was sold in the different currencies in the specific year(input). Final code MUST be very organized. I mean with use of "call" etc. - I have files too 2009 for currency(valuta) and sales(salgsdata) Thank you!