I have a monthly report I have to produce for a director, it has sales data for certain products.

On my sheet I have several months to fill in and several different things to do but I want to try and make the whole process faster.

I have created the whole workbook to update figures when I insert the current report onto a selected tab, this of course filters the information and updates everything, however and this is where I need the help, on 10 pages all products need to be sorted into best sellers. I have multiple sections on one tab so for example:

Column A1:D18 will contain a list of products then F1:I29 will contain a list of different products.

Is there a code that can auto sort multiple ranges?

Thanks