Cleaning all files from the same folder without combining it

I have around 100 excel files in one folder and all of the them have the same format.

I want to clean it in one go instead of combining them into one excel file or refresh 100 times. I want to keep them as separate. Is this possible to do it?

Thank you.