Macro to filter selected sheets

[Kaladubai]

Hi,
I need to create a macro for the use of advanced filter or similar for the following:

I am working on a big workbook with several sheets.
Need to hide "0" values in column "z" (totals) on all sheets i.e. from Sheet 5 to Sheet 20 only and nothing to be done for Sheet 1 to 4.
Each month I will be refreshing the data so i need to unhide everything each month and hide the "0" values again.

Can anyone help with a simple macro. Thanking you in advance. If you need any further info, please let me know.

Regards

[Marc L]

Ok - Titles wa edited …

[Kaladubai]

Hi
Please someone can have a look into this.......

Thanks in advance.
Regards