Archive data from a master sheet to corresponding sheets

I recently came back to the family farm and I am trying to manage our grain sales in a more efficient manner furthermore manage the production history of our individual fields better. A brief explanation of how data flow into the spreadsheet: As the grain is harvested it is delivered to an elevator. At that point we get a truck ticket with weight, bushels and quality information is gathered. Once a particular contract is filled we will get a payment and settlement summary from that elevator tying back to individual truck tickets. I will then go back through the master truck load list and verify that what the summary sheet from the elevator says matches what the original truck ticket says.

To complicate this a bit. Once we finish harvesting a field we will sometimes only have a truck half full of grain so we will start on the next field and top off the load before sending it to the elevator. On the "Data Entry" tab: Columns "Q-V" will be data from the first grain field and columns "W-AB" will be data from the second grain field. Column "B" is the loads as they leave the field (so I can see how many loads we have shipped), column "C" is an indicator to me that it is a load of grain split between 2 fields of grain (if it is a split load I will enter the number 2) it was proving to be too much work to insert a check box for each row. Columns "D-P" is information derived either from the elevator truck ticket or known information and entered into the sheet.

In the future I plan to create a userform to assist with entering this data into the "Data Entry" spreadsheet. At the moment what I am hung up on is how to efficiently search Columns Q and W and move specific data in that row to the corresponding tabs labeled Field 1, field 2 etc. I have an ActiveX command button on the page to search and send data to the corresponding fields. I am wanting to keep this code as simple as possible because I will be duplicating it to sort data to other data in the same manner.

I appreciate any help the experts can provide.

rlh