Auto Populate Worksheets From A Master List

I have a master list that I want to type repair orders into. I want that list to auto populate the appropriate worksheet. I have only one criteria and that is to sort by truck or trailer number. I have tried a small macro and an amazing if then list but I just can't get it to work. Can anyone help before I spend a fortune trying to get someone to do it for me?

Thanks