I want to create a sheet containing all of the data from multiple sheets (or workbooks).

The good news is that each of the source sheets follow the same template with the same column headings.

To give you an idea of the objective I need an overall consolidated sheet containing all of the information in the original source sheets. So for example I have a sheet containing systems for our MI team and one for systems for our claims team. The destination sheet should contain info from both teams in the same sheet.

Ideally this would be linked so that it is updated when the destination sheet is opened, however if this is not possible then I would imagine it would be no trouble to assign a macro to the task of pulling the data together.

Any takers???

Cheers

Mark.