Get a report from many excel files

[magicool]

Hi,
This is a bit complicated to explain but I’ll do my best. If more info is needed I’ll be more than happy to post it.
I calculate payments for my employees in excel. Every employee has a sheet in a workbook. I have a “Main” sheet with a list of employees. Every employee’s sheet has same fields (also a field with his/her name) and are named: 1, 2 ,3….. I create a new workbook every 2 weeks, or so, by copying the previous workbook to a new one, clean all the previous numbers, put the new numbers and add or replace people in the sheets.
I need a separate workbook to get some graphical overview of the performance of each employee for each activity over time. Now I do this by hand and is very time consuming and I can easily make mistakes.
How to extract the data that I need automatically? Please check the attach to see a demo.
Thank you!

[Mallycat]

Hi,
Every employee has a sheet in a workbook.

This is actually your problem. You should put all the data in one sheet in a table, and then use pivot tables to do your reporting

[Mallycat]

here is a sample

[magicool]

Hi,
I am trying to understand:
First I must create for every workbook a sheet containing all the interesting data from the other sheets and after create a new workbook to extract the data from all the other workbooks?
The end result I need is to get a graphical representation for the evolution of each employee on every activity depending on the date (please check the picture in the attach).