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.

Wow - it's starting to take shape
The macro inserts a couple columns incorrectly.
On NVA
should place cancel reason in Column E not F; the Cancel Date goes into Col F not G; and the Facility goes to Col G not H
On the TPNO
Should place Cancel reason in Column E not F; The Cancel Date goes into Col F not G - G is missing the Transportation Provider -The Facility is correct in H

I'm amazed at how you did this and I'm trying to understand your code.

The TPNO headers are slightly different than the NVA - Transportation Provider from colAA goes in col G of the TPNO - The NVA worksheet does not get a Transportation Provider column.
The Facility on the TPNO is one column to the right of where it would be on the NVA worksheet - If it is easier I can swap the headers for Facility and Transportation Provider - then just need Transportation provider to populate
Which ever is easier.

Thanks
Jim

Thanks Orrin
Appreciate it - great use of code and helper sheets.
Jim

Thanks Orrin
Appreciate it - great use of code and helper sheets.
Jim