Macro to transfer data from one sheet to other

[paul_sykes00]

Hi,

Hope someone can help me with this. Its pretty complicated so i'll be impressed

I have a time sheet for each member of staff. Please see attached examples "Tech 1 - Time Sheets" and "Tech 2 - Time Sheets". The only differences between the 2 will be:
1) Staff Name (cell D3)
2) Job Number (column A)
3) Job Name (column B)
4) Job Type (column C)
5) Hrs spent on job (columns E to K)
6) File name (column E)

I also I have a series of service reports. Please see attached examples "10001(S) - Job 2" and "10001(S) - Job 2". There layout will be identical

I need a macro in each of the time sheets which will open the file name in column L and transfer all the information to the service sheets.

For example i'll open a time sheet, run the macro and starting with row 16 it will open the file given in cell L16, extract data in cells A16:L16 and place data in the service reports as highlighted in the red cells in the service reports. After row 16, the macro would move onto row 17 and onwards until all data is entered. Once the macro has been run the first time sheet, the same macro would be run in the 2nd timesheet. The result should be that the data will be entered as highlighted in the red cells of the service report (E47:I65).

For now we can say all the files are saved on say C:\ drive

Thanks in advance for your help,

Paul