You believe :Lines where the VALUE in the "Amount" column is blank or 0
should be hidden. (Right)
You believe :Data is changed in the "Data" tab. When the "Summary" sheet
is selected,
the data is automatically updated, and the blank or 0
value lines will be hidden.(Right)
=====================================================
Further, yes I already have "Summary" sheet  working to summarize the data.
First, I can record macro but can not understand VBA language so, I need
individual steps.
Secondly, I am not familiar with "loop" function.
So I couldn't go to next steps you advised me.
(In the end I expect VBA code to extract the summary  sheet)