VBA Categorical copying and pasting without linkage

Hi There -

I am trying to create an excel VBA to do some copying and pasting based on criteria listed in the workbook. I am trying to take Unload Tons & Net MT from the daily unloads tab (normally a separate spreadsheet) and place the into an existing spreadsheet, containing the other named tabs. The data needs to be placed in the correct tab, according to the farm ID column in the daily unloads spreadsheet (corresponding to a tab in the other spreadsheet). The Unload Tons & Net MT needs to be matched and copied according correct car number in the tab (under "car number column" in one spreadsheet, and simply in column "A" in the daily unloads spreadsheet). I need to update the spreadsheet containing the matched car number with the Unload Tons & Net MT and send the information out (along with all previous updates in the spreadsheet remaining intact) without linkage. Car numbers may repeat as well, however shouldnt be an issue if matching from the bottom of the sheet first, as car numbers dont reappear close together. The daily unload spreadsheet is new daily, and updates must be made accordingly. I am familiar with some aspects of VBA and have done a variety of formatting with it, but never something quite like this. Any help would be greatly appreciated!
Thanks!!!