Create summary table automatically

When you highlight a set of records you can see whatever you choose in the right of the status bar (usually max, min, average). Is there a way to select a range and dump a summary table like that into a new sheet or location on another sheet? It would be nice if it would auto-update but if it's a static set of values I guess that's better than nothing. I could probably write a macro but there's gotta be something out there already!

Thanks!