Hide/unhidden rows in protected workbook multiple sheets

Hi there,

Is a time sheet for a company with multiple bars with each bar having different amount of staff, the idea is when you add names (Column B) in the payroll information sheet, that will be the only rows showing in the rest of the book (week 1 to week 5 + total sheets). I saw in the forum that the only way is with a code (too big for me I am afraid!).

I will appreciate any help on that.

Attach the file, feel free to ask any question if i haven't explain myself.

many thanks.

What do you mean by bars?