Replace text number with some other number based on the sheet

Hello Experts,
I am a novice to excel and I have a very easy requirement. I have same text on 25 different sheet. I want to replace the number in text with the number corresponding to sheet number.

For example. The text in all the 25 sheets is "text01" it should be "text02" in sheet2, "text03" in sheet3 and so on till 25. Please keep in mind I want 01 to be replaced by 02, 03....11,12....,24,25 etc. not single digit "1" (should be "01")

For your reference I have attached an excel sheet with 6 sheet original excel sheet has 25 sheets and the length of the text is variable. Waiting for expert replies.

Thanks,
Amandeeo

Hi wenqq3,
Thank you for your reply. Sorry for not putting it correctly. All the text having 01 are not the same they are all different text's. That is why I wanted to replace 01 by the two digit sheet number (if sheet 2 the replace 01 by 02 not 1, because there is 1 in other places and I want it to be the same, only 01 by some the sheet number). I hope this clears it a bit more.

Hey thanks, really helpful!!