Creating macro to populate specific cells from master sheet to work sheet

Hi all,

I'm trying to write a macro that copies specific cells from a large spreadsheet of data onto another sheet. Eg. The job number from the Sales Enquiries sheet (A5) needs to be copied (values only, no formatting) into the Job Sheet (I2), the Scope of Work (Sales Enquiries, A5) needs to be copied to Job Sheet B16 etc. Likewise, the values in the Sales Enquiries J5:M5 needs to be copied to Machining Task Sheet H12:H15. PLEASE NOTE: not all information on the Sales Enquiries sheet is relevant to the other sheets, so the cell pairings are colour-coded in the example sheet attached.

This macro needs to be relative, so that when I have the active cell as a job number in the Sales Enquiries sheet (column A) when I run the macro, it auto-populates the relevant row with the relevant data from that same row (eg. A569 would populate the other sheets with the selected cells from row 569 and so on). I would like the macro to execute using Ctrl + Shift + Z.

I have set up the Machining Task Sheet to simply extract some of the data from the relevant cells on the Job Summary sheet, so no macro required except for the hours (column H). When I try to simply record the macro using this copy/paste method, the macro returns a run-time error and does not work. If I record just one task like copying the job number, it works fine. But when I try to include the multiple cells as required, it returns an error.

Any help would be much appreciated!!

Tatyana