I have a Master Table on Sheet 1, The following sheets use formulas to extract information from Sheet 1. I would like to rename Sheets 2 through 30 with the contents of cell B1 of that particular sheet. Is it possible to use a formula in the sheet name field to name the sheet ?
example:
If I make a change on Sheet 1, I want that change to be made in cell B1 on the corresponding sheet (which it does) but I would also like that change to be made to the Sheet Name