How to use the column header to retrieved values from a table

[MyStix01]

Hi,

Appreciate is someone could help me out on what formula to use under cell A4 and all the way down, sheet Masterfile.
Basically, what I want to happen is for the values to auto populate in Masterfile sheet once I paste the extracted report in sheet WIP DATA.
The cell where the first job number value in WIP DATA would land is not fix, so I'm thinking the best way to do this is, all values under the word "Job Number" in WIP DATA should feed through in the Masterfile - Job Number column.

Please see attached file.

Thank you!

[samba_ravi]

MAY BE THE BELOW
A4=IFERROR(INDEX('WIP DATA'!$D$12:$W$131,ROWS(A$3:A4),MATCH(A$3,'WIP DATA'!$D$12:$U$12,0)),"")
Try this and copy across

[MyStix01]

Thanks for this! It works perfectly!