I've got a table with columns of Sales Reps names and their Total Sales.

I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them as constants -
with range names, say, 'High' and 'Low'.

If possible I want the table of the highes figures above the one with the
lowest - so I can print off onto one piece of paper.

How do I do it, bearing in mind the number of rows will change depending on
the values I put if for 'High' and 'Low'

TIA