i have my sheet for sum a lot of other sheets.
in my sheet i have placed an autofilter at column header, especialy
interested in last column

in other sheets user will enter a lot of values and last column is changed
as total sum of that values

for listing porposes i wish to filter automatically my sheet every time when
a value from a last column of my sheet is greater than 0
or when i click on sheet tab of my sheet
just those rows who have values grater than 0 must to be listed.

Thanks a lot !