I have around 10 worksheets .....5 contains the word "[Trend]" in their
sheet name for example "Product1 [Trend]"

I want a Macro that can search for word "[Trend]" in available worksheets
and delete this word or replace it with some other text..so that worksheet
rename as "Product1".

Is it possible...?

Thank you,
Murtaza