Is there a way to automatically copy filtered content from sheet A to sheet B daily?


I have a sheet (sheet A) that is my source sheet, and the content is updated frequently.

I'd like to filter sheet A on a particular column, and copy the filtered content to another sheet (sheet B) to share with my users, automatically at a daily basis. Before copy, content in sheet B needs to be cleared.

I tried to use the "Automation" -> Create Workflow -> Copy Rows, however, I don't know how to clear the content in sheet B before each day's copy, right now the sheet B is keeping growing every day...

Thanks for the help in advance!