Good morning all

I have 4 worksheets with information on them, all worksheets have the following;

Name
Referance
Date

What i want is a formula on another worksheet that will read all the information on all 4 worksheets and place it into a list depending on the name, the name would be a validation list in cell A1

Thanks in advance

DJ