Summarizing/sorting URLs by frequency

Hey all,

I'm working on an Excel sheet for something at work and trying to do some analysis reporting on some data I've collected. Long story short, I've got about 600 website URLs collected and sorted into a 3x200 area (3 columns, 200 rows; all in "www.URL.com" format (OKAY, well, technically there's like 7 sheets in this doc each with 30 URLs and I'm trying to get analysis on sheet 8). Is there a way that I can have a "Summary" sheet on a separate page that can tally up the website URLs and see which are most frequent? Or any other tools for summarizing the data into quick little info bites.

Thanks!

-=MORE INFO BELOW=-

Here is an attached file as an example: testdoc2.xlsx


The first 2 sheets have 3 columns with assorted web addresses and the 3rd sheet has a summary page. I'd like the summary page to look at the URLs present in sheets 1 and 2 and summarize them in highest-lowest order in sheet 3 along with a tally of frequency in the column beside the one showing the web addresses.

I can clarify more if it is not clear.

-=ANOTHER REQUEST=-

This one is a bit more simple, so I don't think I'll have to upload a sheet. How can I take a column that is filled with words and numbers. Say:

Food
Color
12
18
B
27
Elec
888
Love
16
x

And have three summary cells where it will identify the lowest number, highest number, and average across all numbers while ignoring any words that are within, say, A1:A15?