Hello!

Every Monday I recieve a worksheet from 10 different team members, about
there departments percentages, etc. I think manually take some data off those
sheets (which are all exact) and then enter it into another document,
"summary page".

I do this with mulitple reports and this takes many hours. Isnt there a way
for me to have this automatically inserted, or macros'd in?

I would like to avoid having to search for all these numbers on there docs
and manually enter them into my doc.

Can you help!? I am running MS Excel 2007.