Data from multiple workbooks

[Guest]

I suspect this may be easier to do in access but maybe you know a way in excel.

I have multiple excel files that all have the same headings. Users will be
entering data into these workbooks.

Once they have been filled in, I want to be able to easily extract the data
from the mutltiple workbooks and bring them into 1 workbook so I can then
interrogate the data (filter etc).

Is there an easy way rather than copying and pasting each time?

 

[Roger Govier]

Hi Burt

Ron de Bruin has lots of code at his site to deal with copying data from
other sheets or other workbooks to a single sheet.
http://www.rondebruin.nl/summary2.htm