I have a workbook for product sales data. each sheet in the workbook
contains data for different product and inside each sheet, salespersons and
their data exists.
I send this file to all of my sales persons, they filter the sheets to their
own name, enter relevant data and return it back to me by email. Now I have
many files.

Now I have to consolidate the returned files to make a single file and send
it to my boss.

First q) How can I consolidate these files?

Second Q) It seams that my original table design is not good. It would be
better to separate salespersons to different

sheets. This way it is easier to consolidate.


--
Rasoul Khoshravan Azar