Macro to find a value in excel

Hi Nguyen,

Thanks for helping. Do you min to explain your approach in detailed?

I am not sure what range to put since each sheet has a unique name.