Retrieving Data and updating cells across Worksheets

Hi I am an OLD ex It manager who is now having to do his own Excel work. I have a spreadsheet that has a an "Equiry Sheet" that retrieves date from a second "Employee Data Sheet" using the employee number as the reference( using VLOOKUP), I would now like to make this UPDATE capable. How do I write the data back when I have retrieved it via VLOOKUP? I know the cell reference where I want to write back but I cannot get my Macro to work. This is the coding I am trying to use :-

Sub UPdatedata()

Set W1 = Worksheets("Enquiry")
Set W2 = Worksheets("Master Data")


W1.Select
Range("I15").Copy

W2.Select
Range(indirect('Enquiry'!L8)).PasteSpecial

End Sub

Any Help would be appreciated
Thanks
David Steel (Old EX- IT Manager)

Please use code tags with your code.

There is no indirect VBA function.