Linking filtered data to other worksheets.

Using Autofilter, I want to use the Subtotal function to find the sum and average of my filtered data. I want to display the results of this function on a different worksheet from where the filtered data is shown. I know the parameters 101 - 109 are specified to show the filtered data only, my problem is getting the results onto my other worksheet. I would appreciate help.

Thanks for your suggestion but I must admit I am not too familiar with pivot tables. Maybe I should try them out. The data I need to work on consists of the bowling figures (cricket) of the current English Test bowlers. These figures are updated with each match played and I would like the calculations based on the updated records to be automatically adjusted in my separate Statistics worksheet. I would like to go into further detail but unless you like cricket, I think I might bore you incredibly.

I've realised that what I want to achieve cannot be done without some manual selecting of target cells to receive packets of filtered data which need to be displayed side by side. It just means I will have to press a few more keys to get the desired result. But I do thank you for offering to help and no doubt I will have other questions in the near future.