Hi. I am very new to VBA and need some help on how to sort my data by multiple columns in several sheets and then delete some specific rows.

All my sheets have the same number of columns (from A to AI), but different number of rows (these could be e.g. 900 or 5900). My data has headers. The number of sheets I need to work on can vary year on year, but usually is more than 50.

Firstly I need to sort columns B and column C by values A to Z. I also need to sort column F by a custom list, whose list entries are "% Agree" and "Mean score". There are other values included under the column F but these don't need to be sorted. I basically need to have "% agree" and "mean score" first.

I then need to apply this sorting to all my sheets within my workbook.

Secondly, I need to delete those rows that have the following values in column D: "sector-wide" or "Sector Wide" in every sheet.

Hope you can help with this. Thank you very much.