How to gather data from different excel workbooks into 1?

[Guest]

Suppose we have several different workbooks (not shared) containing the same
fields on a server location.Each user update his own workbook daily.I need
(the controler) to gather the data in another workbook and report the daily
updates for all the users in a table,but needs it to be automatic, and
showing these results in detail.I have a perfect background but don't know
how to connect the points.Please help,thank you.

 

[Dave Peterson]

Ron de Bruin has lots of code at:
http://www.rondebruin.nl/copy3.htm

Maybe you could steal some of it to merge the worksheets into one giant
worksheet and process your data from there.

 

[Guest]

You can also extract the data from the other workbooks into your own workbook
through Data/Import External Data/New Database Query. Once you have the data
in your spreadsheet you can combine the data into one table by using the same
method but use a union query on each sheet to combine them together. You can
have your queries set up for automatic refreshing by setting the query
properties.