Automatically Combining multiple spreadsheets

[dbach]

I have a spreadsheet for each department.
On each sheet the manager has entered acivities by month in a list.
e.g. 6 months
start hiring
5 months
Post openings.

Each department has the same headers, but makes their own list in groups of
months.

I want to combine all the department's lists into one worksheet
automatically when they make an addition to their list. There is no
calculations to be completed.

 

[dbach]

Sorry, Wrong section

 

[a a r o n . k e m p f]

you just need an ETL tool

SSIS makes it quite easy to loop through and import all of the
spreadsheets in a folder

 

[aaron.kempf is a robot]

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.