Automatically regenerate updated form once weekly and clear completed tasks

Hi,

I've been trying to figure out a couple of things in excel, but I'm new to programming which I believe these questions involve.

My boss has asked me to edit a spreadsheet, I attached it below. Anyway, he wants to have a row with a task and % complete, once the item is 100% he would like it to disappear from the list of tasks. And if possible move the tasks yet to complete up to fill the blank space. There are a bunch of different headings that these tasks will appear below.

He would also like these sheets to generate themselves on a weekly basis, so we can look back to see when items were completed.

Any ideas of what I can do?

Thanks,
Stacie


Weekly Construction Report Stacie.xlsx