I have a number of team workbooks which each contain a summary sheet of data.
I want to create a new workbook for all the teams that takes and merges the
summary sheets from each workbook to a larger summary sheet of all the teams
in the new workbook. The format will be the same.

Is there an easy way to do this or do we need to write a Macro????