Change ws3 Cell Content Depending On ws1 Content

What would be the best way to achieve the following on the attached workbook?

The cells on columns D & E of sheets 1 & 2 can be blank or have text. If the ‘Save Sheet 1’ button is clicked I’d like to achieve the following;
If the cells in columns D & E have text present then enter the text ‘ Complete’ into Sheet 3, Cell C2 and Save the workbook.
If the cells in columns D & E have no text present then enter the text ‘In Progress’ into Sheet 3, Cell C2 and Save the workbook.
The same would apply for Sheet 2 with associated Sheet 3, Cell C4.

In addition if a sheet is complete, ideally I would like to remove this sheet from the workbook and save to another location as a pdf file.

Any advice gratefully received.

Thanks Marcol. This works great for changing the ws3 cells but how can this be adapted to save the ws to another folder if it is complete or save in existing workbook if incomplete?