How Can You Dynamically Change Excel Sheet Names Using Cell References?

Hi, this week, I am addressing an interesting question that I received from one of my participants. The question was: how can we use a cell reference to change the sheet names in our formulas? The attached file illustrates how we can change the sheet names in the formula by using a cell reference. Wishing you a great week ahead. Thank you.

Regards,
Hariharan Ramakrishnan
Microsoft Office Trainer/Consultant