Gareth,

Here is a quick macro that seems to work, as I dont know your criteria or
columns etc... its a rough idea of what could be done.
Note: please create a tab named "Summary"

Public Sub Comb_Summary()

For Each sh In Sheets
sh.Select
If ActiveSheet.Name < "Summary" Then
sh.UsedRange.Copy
Sheets("Summary").Select
x = WorksheetFunction.CountA(Columns("A:A"))
Cells(x + 1, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
If x < 0 Then
Rows(x + 1).Delete
End If
End If
Next

End Sub
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Gareth" wrote:

Hi Thomas

yes all 3 worksheets are in same workbook / file.

ta

"Thomas [PBD]" wrote:

Gareth,

Are all of these Worksheets in the same Workbook? It can be easier to write
a macro to combine the information into the 4th sheet if so.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Gareth" wrote:

Thanks thomas

i have had a look at this and seems somewhart complicated for what i am
asking.




"Thomas [PBD]" wrote:

Gareth,

I recommend starting he
http://www.rondebruin.nl/tips.htm

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Gareth" wrote:

Hi all

As aprt of doing a mail merge I need data from 3 worksheets to be summarised
in a 4th worksheet for mail merge reasons.

So what i have currently is a bunch of colums and rows whcih will
continously added to. Currently have around 100 candicates and on each person
there are several further colums for their data. Each person has a similar
setup in 2 other worksheets for different sets of data.

What i want is basically the 4th worksheet to show all of these and also
whenever more data is added to either sheet, this is added to the 4th
worksheet....


Thanks in advance.