is there a way to tell Filtering to Keep only certain fields instead of only removing them

I have a Macro I'm using that Filters out data that I dont need, but the data changes several times a day

I need it to Delete Everything I dont need and only leave behind the stuff I want

so right now... they way I have to do it, is to tell it to filter by known items that I want to get rid of, then tell it to delete those items and then undo the filter, which leaves the items I do want still sitting there

we keep adding new categories, which means I have to add that category to my list of thins to tell the macro to delete

Is there a way that I can make the macro only keep the data I want and not have to tell it to delete the specific data I dont want?

the report I import the data from(manual copy and paste to the other sheet)
and my sheet are attached...
Macro Runs by pressing CTRL+SHIFT+D

Right now the Macro process is
Filter Data... keep "X" Categories"
Delete all lines showing
Undo Filter...(leaves all the rest of the items showing)
sort by Date and Time
populate Pivot table and barcode counts sheet


this honestly works fine until they add more categories from new stuff... and then I have to go back in and edit that category list

and because this is a shared sheet on a onedrive sharepoint server, I can only edit it when nobody is using it.. which basically only means late at night. which I'm trying to avoid having to deal with this late night at home away from work when I have better things to do.

Also....
along the same lines as using Filters...
Is there a way to tell it in a MAcro to Filter by one Letter.... so that all the numbers in a certain column that begin with the Letter T can be automatically removed??

example being Column F.. some ate T1234567....
I want to tell it to remove all the T's no matter what the other 7 numbers are...
When I try to record a macro, it does individual order numbers and I just want to tell it generically T* and make them all go away