Copy and paste values

in the attached, sheet 1 would be the job tracker and sheet 2 would be the individual job sheet.

IRL these are in seperate workbooks but for ease of purpose here they are in the same file.
Some of the blank columns in my real tracker sheet have vlookups in them to the individual job sheets, some are just blank.

I want a macro to fill in the blank columns based on the booking reference and then copy the whole row and paste values (to get rid of the vlookups)

The macro would be stored in the individual sheet and each individual sheet has a different file name so swapping sheets must use a reference such as activate.thisworkbook, rather than an absolute filename

Does this make any more sense ?


NOTE: the information in my real job sheet is not in row format as it appears here it is in various different cells and columns.