Please see the image
VBA need to check the summary sheet .
In summary_sheet and column A has sheet name for all sheets
In summary_sheet and column C has row count for all sheets
VBA need to do two things
1-Hide sheet if row count is zero .
2-Give hyper link on column A's each cell so user can go to each sheet directly by clicking on it .
for example some thing like this .
For Each ws In ActiveWorkbook.Sheets