Good morning all!


I have about 60 sheets in one book, all with very different names. Each sheet has the same exact list of data.

I need a macro that will go through each sheet and delete all rows, except for the header, in which the data in column D does not match the sheet name. If possible, can it also delete the row formatting as well so I dont have to go back and do this manually?

I appreciate any help that can be provided!