auto hide of rows based on column info

Hi

Having a look at the attached spreadsheet will help with this question. i have tabs monday to wednesday and then a weekly total one. i will enter info in the monday to wednesday and it will give totals in the total tab. columns i'll be editing are G, H, I, M & N. from the weekly total tab i want to be able to run something where it hides the rows which dont have info in, apart from the headings if this is possible.

i'm pretty basic to excel but any help would greatly be appreciated. or would it be easier to link it to access?

thanks

Pete