Cleaning up columns macro

[Tigerexcel]

I thought this would be easy but I haven't found much on this topic. I receive data dumps where I have to remove various columns of data as part of the reports that I have to produce. The particular columns that will need to be deleted don't always arrive in the same order. A typical example of column headings would be:
ID Name Age Position Status etc. What VBA coding would I need to delete Status and Age for example.
I regularly receive data sheets with over 30 column and have to delete at least half of them but they tend to be the same ones.

 

[Norie]

When you delete a column/row the rest of the columns/rows change position so you can end up skipping columns/rows.