How to hide rows based on value in a different cell

Good afternoon

I am trying to write a VBA code to make things easier for staff using a QC run sheet (hopefully attached) in a printing company where I work.

Firstly, based on value's in J16 - J24, I want it to hide tabs, which I believe I have got to work.

Secondly, based on the values in the same cells as above, I then want it to hide rows in the "Front Sheet V2" so for example, if J18 = "No", then rows 43 - 56 would be hidden (corresponding section on the same worksheet).
This only works if all (J16 - J24) and clicked as "Yes", otherwise it repeats columns which I can not understand).

Thirdly, based on the value (1 - 6) in cell J26, I then want it to hide rows under each sub heading, so again for example, if J26 = 3 and J16 = "Yes" then Rows 37 - 41 would be hidden. Again this only works if J16 - J24 are all checked as yes, otherwise it duplicates rows.

Finally, based on the value in J26, I then want to hide rows in the corresponding tabs, so using the example above, rows "28 - 33" would be hidden on the "DIGITAL V2" tab.

I have had a good go, but I have no experience in VBA although willing to learn hence I tried to do it myself (with a little help from google)

Thank you both, I told you I was a newbie at VBA... rookie mistake. AlphaFrog your script works perfectly, thank you so so much!