vlookup error

[chris2727272727]

e = ("\\office_server\my documents\thames valley\[thames valley database.xls]employee contacts!$b$16:$i$137")


Range("d14").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("e14").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("b18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("c18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("d18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("e18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("f18").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)
Range("d14").Value = Application.WorksheetFunction.VLookup("97324", e, 3, False)


i have the above code but when it runs the below error comes up why is that

run time eroor '1004' unable to get the vlookup property of the worksheetfunction class

 

[chris2727272727]

well i have seven sheets the master sheet is sheet 1 all the other sheets have the same data which was put there by pastelink what i want is when the code deletes a row on sheet 1 it deletes that same row on sheet 2 sheet 3 sheet4 sheet5 and sheet6.

The only problem might be that row 1 on sheet1 might be on row 3 on sheet2 and row 5 on sheet 3 etc etc