VBA to filter, cut, and paste to new tab, deleting each time

[jmcnaught]

I am trying to figure out how to filter, cut and paste to new tab in worksheet. I want to delete the rows copied to the new tab. I am able to create and name the new tabs, now I need to filter for each variable. The number or rows for each changes weekly, but the variables filtered are the same each week.

Here are the variables.

apebu
bridgek
EXTERNAL
jackij
kbridge
lsmith5
nadins
nhicks
prathml
scalea
unassigned
vendbur


Any assistance would be appreciated. Thank you.