Is there a way to change the sheet name indicated in formulas and not do it one by one?

[PeytPeyt]

I am doing a summary for multiple sheets and have 6 formulas that would point to each sheet. I have already extracted all the sheet names and there are 32 sheet and I need to do this to multiple workbooks, I just need to know if there is a less painful way of changing the sheet names and not change them one by one.

If it helps, here are the formulas
Column D. ='SHEET1'!$B$6
Column E. ='SHEET1'!$E$32
Column F. ='SHEET1'!$B$4
Column G. ='SHEET1'!$G$32
Column H. =IF(ABS(MIN('SHEET1'!$G$13:$G$31))>=MAX('SHEET1'!$G$13:$G$31),MIN('SHEET1'!$G$13:$G$31),MAX('SHEET1'!$G$13:$G$31))
Column I. =XLOOKUP(H21,'SHEET1'!$G$12:$G$20,'SHEET1'!$B$12:$B$20)

 

[KevCarter]

You can use the Find & Replace Dialog. It will replace your selected text one by one or all at once, whatever you select.

 

[PeytPeyt]

Yes, that's what I'm doing now. What I'm looking for is if there is a better way to do this. As I will be doing this to multiple workbooks with more than 100 sheets each.

 

[Akuini]

if there is a less painful way of changing the sheet names and not change them one by one.

Change sheet names to what?

 

[PeytPeyt]

For example, the formula that I have sent up top
Column D. ='SHEET1'!$B$6
Column E. ='SHEET1'!$E$32
Column F. ='SHEET1'!$B$4
Column G. ='SHEET1'!$G$32
Column H. =IF(ABS(MIN('SHEET1'!$G$13:$G$31))>=MAX('SHEET1'!$G$13:$G$31),MIN('SHEET1'!$G$13:$G$31),MAX('SHEET1'!$G$13:$G$31))
Column I. =XLOOKUP(H21,'SHEET1'!$G$12:$G$20,'SHEET1'!$B$12:$B$20)

I want to change SHEET1 to SHEET 2 onwards.

 

[Akuini]

I want to change SHEET1 to SHEET 2 onwards.

I don't understand, you mean in formula in all sheet you want to change SHEET1 to SHEET2?

 

[PeytPeyt]

I want to change all SHEET1 values in the formula to SHEET2

 

[Akuini]

I want to change all SHEET1 values in the formula to SHEET2

In Find-Replace Dialog you can choose Within Workbook, so it will find & replace in all sheets at once.

 

[PeytPeyt]

I will be summarizing at least 100 sheets, each row will summarize one sheet which is why I'm looking for another way to do it one by one. I tried the find-replace dialog at first but it's prone to errors and is tedious.

 

[Akuini]

I think you need to explain your problem in more detailed because your explanation is confusing, you said:

I want to change all SHEET1 values in the formula to SHEET2

if that's all then it's easy to do it all at once regardless of how many sheets there are.
but then you said:

each row will summarize one sheet which is why I'm looking for another way to do it one by one.

so can you explain more?

If you mean you a have a list of old-text & new-text to be used in Find-Replace then we can probably use VBA to do the task.