VBA代码，用于对名称未知的所有工作表和工作簿执行操作

I have many reports that all have subtotals in them which I do not need. They are all on a line with a unique number then "Total"(bolded). I am trying to create code that will apply to all of my workbooks as I create new ones that will find and delete any row that has the "Total"(bold) text in it. I know how to apply it to specific workbooks/worksheets with names that I know but do not know how to get it to apply to any worksheet with any name as they come up. I have many reports that all have subtotals in