Hi There!

This might be a redundant kind of question on this forum.

The scenario is like this:
I work as the executive assistant to the Chairman of my company.
I need to collect data (in forms of rows from various excel sheets that various departments populate everyday morning) to one excel sheet that I send as a daily update to the Chairman.

This is a very monotonous job as there are various directories on the common drive of our intranet where these departments have saved their report workbooks. I need to each of them (around 15, at least) to copy a single row from them.

Even though I am not a computer background guy, I tried to copy and test a few macros from various websites, but none came to my rescue.

Could you please provide some help to me?

We are using Excel 2007 and soon we are to upgrade to 2010 version.

Thanks in advance.