Hello. This is a three-tiered question. The first, what VBA code do I need to program the Summary for Invoicing tab to hide a row once a date is entered in column a?

The second question: Can I hide an entire tab using VBA code? If so, what code will I need for each tab (that is not the Summary tab) that once 'Y' is typed in column S, the entire tab is hidden?

Third question: Once I copy the Template tab to a new tab and rename it, can I program the Summary Tab to automatically fill in the new data from New tab, row 6, starting with column b to the next available row in Summary tab, also starting in column b?
Macro to Hide Row Once Date is in Cell, for Excel Forum.xlsx

Thank you.