Macro That deletes rows based on date and text

I'm slowly trying to automate a weekly report that I put together every Monday (sometimes Tuesday). The example I attached is from Monday 7/3 and hope to be able to use this macro on 7/10 or 7/11.

I need a macro that will delete the row if the text in Column H starts with "auto" ("auto*" if was used in a formula) AND the date in column C is the previous Thursday thru Current date (6/29,6/30,7/1,7/3,7/4) .

In this example, 8 rows should end up being deleted. This data is usually 15,000 ish rows long and the dates update every week.

Thank you so much in advance