I have a two part question:
1. How do I automatically take data from one tab and sort the data based on
the frequency the numbers are used and paste that data into another tab
showing a column with the data and the frequency the data occurred.

2. Automatically take the data generated above and copy and paste them from
columns to rows based on the top 40 numbers generated above.

Also how can I set a data range for calculations that gets updated weekly
without having to go back and update the range.