VBA copy paste sort refresh
 

I am trying to figure out how to copy data from one sheet to another
that meets a specific parameter using VBA. I have a web query on sheet
1 that refreshes every 3 minutes. I would like to select all rows from
it that have a value in column C that is, for example, greater than
100; copy only those rows into sheet 2, and after they have been
copied, sort them by, for example, ascending order of column A. I need
sheet 2 to automatically refresh every 3 minutes as well. It would be
nice to learn how to do this all in VBA, as I have C++ experience and
am comfortable coding solutions.

Thanks for any help, I know I'm asking a lot.