The 1st question is kind of vague. Look at the built in data analysis
choices on the tools menu. If those are not what you need, maybe we
can help if you can be more specific.
For the second question, you can record macros of selecting each
sheet, then add buttons to the sheets and assign the macros to the
buttons. To add buttons, go to View – Toolbars – Forms and you will
see the button tool. Right click a button to assign a macro to it.