Transferdata from 1 sheet to other sheets criteria

Greetings!

I have been trying to look for vba codes and formulas but am still at a lost as to how to even start. Am a total newbie at this whole vba/excel formula thing. Please help me!

I am trying to gather data from 14 different companies which will be testing 5 items each, into one excel workbook.

Each lab has the freedom to use different amplification kits when testing the 5 items. i've listed the amplification kits using a dropdown list via the LOOKUP function.

I then created the following sheets:
'transferdata'
'item 1' to 'item 5'

All the companies will receive the same table seen in 'transferdata' sheet for them to key in their data.

I will then paste data received from each company onto the 'transferdata' sheet of my own workbook.

Based on the type of amplification kits and company number. ,
How can i go about transferring data from the 'transferdata' sheet onto the rest of the sheets? I have also added a commandbutton but again, i'm not sure how that will work.

Below is the link to the workbook that i've created
https://www.dropbox.com/s/npwb4zxpk20quwv/14companiesdata%20.xlsm?dl=0


I'm really lost. Please guide me.

Really appreciate all the help i can get.
Thank you!

Sheiraa