Automating a report?

Hi,

OK, complicated one!

I have a report that counts how much work a person has done per day. This is basically a summary report for managers to ensure we are hitting targets etc...

What I have to do every day/week is go into everyone individual excel sheet and physically count how much they've done per day and update the report. There are about 7 or so excel sheets I have to go through.

I was wondering if there is a way of having this report open and count each excel sheet by itself rather than me opening and counting?

Basic counting in closed workbooks can be done with the use of Sumproduct() and perhaps other functions.

An example of one of those reports and an example of what you want for your summary sheet would help.