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.