VLookup query

Hi,

I have designed a spreadsheet and i want a seperate worksheet (sheet3 for arguments sake) to retrieve customer data from worksheet 2 - The data I required is the customer data currently contained on columns A - H and there are around 50 rows. (A2 - I51)

I want the seperate sheet to identify entries that have today's date in column I and then list them in Worksheet 3.

Im having difficulties with the syntax for retrieving the data from a seperate worksheet. There may be several entries for the same date and I want to the seperate sheet to report all customer data in worksheet 3?

Also, if the date falls on a weekend I would like to retrieve any data for the weekend on the Monday so all cases can be reviewed - Is this possible at all?

Im at my wits end trying to do this so any help would be greatly appreciated.

Many thanks in advance.

John.