Linked two sheets together

I have linked a master sample test for a project I am working on.

There is a sample register and sample book I want to link.

I need the sample book to pull key information from the sample register.

This will consist of:

Sample No – I will need this in the form of 1-8 pulling only from the job number range for example as you can see there are 8 samples in a row from one job but in the sample book, I need this to be displayed as 1-8.

Date Received – I need this to be copied to the sample book from the sample register but need to make sure that it is linked to the correct job number.

Client – I need this to be copied to the sample book from the sample register but need to make sure that it is linked to the correct job number

Job Detail - I need this to be copied to the sample book from the sample register but need to make sure that it is linked to the correct job number

Test – In the sample register an x is represented for each test on a specific sample on sample book as the job is summarised for each test, I need the amount of x on the test counted to give the total amount of a specific test done a the job

Essentially the job number in the sample register needs to be linked to the sample book and pull in the key information as outlined above.

I have linked both a word and excel document so you can play about with the excel.

Thank you