Thanks to you all.

A special thank you to both bebo021999 and AlKey . Both solutions worked fine as the sheets can be password protected.