Rename 4 tabs only based on cell value with VBA

[Stuepef]

I have a workbook that has 14 total tabs and I am looking to write VBA to rename only 4 of the 14 tabs. The tabs to be renamed will use cell values on a different tab that contain no illegal characters or length restrictions. I have researched how to write the code, but only found the cell values are in the same spot on each workbook which is not the situation here. If the cell value is blank or 0, I want to rename the tab to "HIDE".

worksheets to be renamed:
Summary 1
Summary (2)
Summary (3)
Summary (4)

worksheet with cell values for renaming:
Overall Summary
cell A24 for Summary 1
cell A25 for Summary (2)
cell A26 for Summary (3)
cell A27 for Summary (4)

Thank you for the help!

 

[Stuepef]

perfect, that works! Thank you!

 

[Fluff]

Glad to help & thanks for the feedback