Linking Worksheets Problem

[andyp161]

Hi there,

This is a bit of a difficult one to explain so please bare with me!!

Is it possible to combine lists in 4 worksheets into 1 master list in
master worksheet, which will organise itself into chronological orde
according to the date which is entered in column A.
For example, if my template was:
Date in A1, Name in A2, and Activity in A3.
And entries in worksheet 1 row 2 were:
01/01/01, Andrew, Tennis
And entries in worksheet 2 row 2 were:
10/01/04, Simon, Soccer
And entries in worksheet 3 row 2 were:
05/01/04, John, Golf
I want my master worksheet to pull the information from worksheet 1,
and 3 as follows:
Row 2: 01/01/01, Andrew, Tennis
Row 3: 05/01/04, John, Golf
Row 4:10/01/04, Simon, Soccer

Hope you can help??

Many thanks

And