Hide row in other sheets based on cell value

Hi everyone, trying to figure this out and can't seem to... any help would be appreciated!

I want to hide rows in multiple other sheets (they are all identical sheets) based on whether a cell on the summary sheet is blank (if cell is blank = hide row, if cell has any text = unhide row).

Here is the code I have so far. It works but will only work for 1 sheet and not all the duplicate sheets. Any help would be great! Thanks!

Dave

Please Login or Register  to view this content.