如何在工作簿中应用VBA代码所有工作表

I'm trying to apply this code but for some reason it doesn't work, can anyone help me fix it? It should delete rows that contain specific text and apply it all the sheets in the workbook. When I try this code, it applies to only one worksheet. Apparently, deleting row part of the code works but not the loop that is supposed to apply to all worksheets.I'm trying to apply this code but for some reas