i want VBA to display values greater than or equal to the given number

[p45cal]

As I said before:

Hiding/unhiding rows with code doesn't work well with autofilters; to get unambiguous results it needs to be autofilter only, or something else without autofilter.

You're discovering this for yourself.
I cannot adjust your code to make it work.
The macro blah is only to re-arrange the data onto Sheet3. You've introduced new fields. I've adjusted blah to cope with your new fields. This rearranged data is the source for the pivot table. I've also adjusted that pivot table (on sheet3 near cell M9), added a few slicers and used 4 textboxes:
Location - enter part of a location and it will filter the list accordingly
Grade - enter part of the name of the group and it will filter. You can also enter 1, 2 or 3 to filter for your own grade groups.
Skill - enter part of a skill name - it will filter immediately.
Skill level - enter a number, it will show that level and above.

Slicers - Click on what you want to filter for.

There is no reset button, just manually clear the textboxes, click the top left x in the slicers.