filter by criteria pivot table or Power Query before output

A daily report I have been asked to review has historically

Exported output from another source in xls format after filtering in the first software - this gives 3 xls outputs which are then renamed as 3 workbooks

A fourth worbook is opened and the links within update from the 3 workbooks just created - the 3 pages within are then printed and emailed - takes on average the bones the bones of 5 minutes

I could compile the reports via VBA but in this instance I think even that would be overkill

What I would like to do is one export of all three data catagories and within the same workbook initiate the creation of a table from an addin

My question is how do I initiate the creation of a table that must be filtered into 2 catagories (forget the third - minor and can be caught later). The filter column is (h) in the attached workbook Daily Defects. The filter catagories are one group starts as numeric the other as a letter. They would require to be trimmed prior to sorting.

The output is the worksheet "Output" and rather than printing 3 sheets as is done now the catagories can just be listed in order with a heading

A point in the right direction would be much appreciated - please ask if anything not clear

I really don't understand the outputs - sorry.

What are the criteria for each of the three?

So do you want just the trucks on the output sheet?

OK - I understand, I think.

Sorry - still confused. In the sample sheet attached to post #1, there seem to be only trucks and trailers - nothing that would class as 'other' based on the reg. numbers. What am I missing here?

OK - I'm out - sorry. I'm just not on the right wavelength with this.

Glad you found a solution.

Cheers, Nige! Horaah for change!!!