Macros programming on attached spreadsheet

Job ID: 33403178

Budget: $30 – $250 USD

I require the following for the attached spreadsheet:
1) Rows 121 to 1200 must be hidden by default
2) When "Yes" is selected in Column O (Under the " Taken Up" heading) for sections listed from row 84 to row 111 then only those sections must appear or unhide.
3) A function button must be available to insert or delete a row without affecting the data, formulas or any programming on the sheet.
4) Any suggestion are welcome