VBA Copying mixed data to specified sheets based on criteria

Attached file
Looking for a macro that will sort data on the TripCancelDetailexport.rpt worksheet to the corresponding NVA and TPNO worksheets into the proper region.
The TPNO and NVA are designated in col X; the region is in col Q
There are two additional worksheets that are samples of how they should look when done (more data obviously) those pages also have light instructions.

Thanks again for all you assistance.