The easiest way would be to set up autofilters on the columns and
set it to "nonblanks"
or "custom" and set to Greater Than 0.
If you're concerned that a user may turn off the filters, or change them,
you can record a macro to turn on the autofilters, and set it the way
you want it, then copy the macro into a change event.

if the Summary tab updates automatically from the the data on the "data" tab,
then you can set the filter in the worksheet_activate event.

How do you WANT it to act?