Return Multiple Values Using VLookUp

I have been trying to return multiple values within a column based on VLookup but cannot seem to find a solution. I need to reference tables different worksheets within the same workbook and here is how the data is set up:

On the Sheet I need the values to appear:

Account Code Date Column where Values would appear
1111 1/01/10
1111 2/01/10
1111 3/01/10
1111 ...
1111
1111
1111
1111
1111
1111
1111
1111 12/01/10
2222 1/01/10
2222
..........................

Behind this sheet are various sheets that are all structured the same as follows:
Account Code Value I need Returned
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
1111 XXXX
2222 XXXX
2222 XXXX

.................

How do I use a Vlookup from the first sheet to match with the following sheets and return the whole column values in order?