Hi @gopal_ram ,
As @Jobin_Joy rightly pointed out, you can use VBA code to hide and unhide the sheets.
There is a video in YouTube please check out , you will get an idea. The video is basically for single sheet, but if you want to work for multiple sheet, then enclose the logic in for each loop.
Way 1 :
For each loop ---- This is for Sheets
use the workflow created in the video
Modify the code, by looping each sheets in VBA or vb.net