VLOOKUP question

Hi,

I need some help using the VLOOKUP Function. I have a work book which I use to enter the stock I sell (with customer ,price, part no ect.) I then have a sheet for each of my big customers. I only fill in the first sheet and want to “copy” all that my big customers buy. My first sheet looks something like this:

Date Name Product
02/09/2007 Mike Apple
05/09/2007 Jhon Pear
07/09/2007 Peter Grapes
11/09/2007 William Apple
15/09/2007 Mike Pear
23/09/2007 peter Grapes


Then there is a sheet for Mike which looks like this :

Date Product
02/09/2007 Apple
15/09/2007 Pear

I want the sheet for mike to update automatically but this happens :

Date Product
02/09/2007 Apple
15/09/2007 Pear
15/09/2007 Pear
15/09/2007 Pear
15/09/2007 Pear
#N/A #N/A
#N/A #N/A

The function created duplicates until the next valid purchase is “copied”. Is there a way around this or should I use a different formula?
Attached is my example .Can anyone assist me in this?