What is the range on each sheet with the data that you wish to copy?
Does the summary sheet exist or must it be created?
Are there any sheets that you don't want to copy data from?
What column headings do you want?
The simplest way is a macro but the above information is needed first.