Sometimes I feel like I step in puddles that have oceans hidden under them.

OP needs to encapsulate existing code in a loop that cycles through all worksheets.

A simple For Each ws / Next loop didn't quite work. I think something in existing code is stopping it.

https://www.excelforum.com/showthread.php?t=1014069