Forum Discussion

Copper Contributor

Nov 12, 2025

Worksheet tabs to include date from a cell

Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the d...

excel

office 365

rbellman

Copper Contributor

Jan 02, 2026

Thank you!! There is one minor issue; cell H1 on tab 3 is linked to cell H1 on tab 1, so when I update the date in H1 on tab 1, cell H1 on tab 3 also updates. When the date changes in H1 on tab 1, the date in the tab name updates as it should, but the tab name on tab 3 does NOT update. I would like the tab names on both tabs 1 and 3 to update when I change the date in cell H1 on tab 1. Thank you for your assistance.

SnowMan55

Bronze Contributor

Jan 07, 2026

Assuming that your "linked to cell H1 on tab 1" means that H1 on the user-input worksheet is referenced in an Excel formula on another tab, yes, that can be handled, in one of at least two ways.

I will try attaching a workbook (built from Lorenzo's starting work). The forum software may or may not accept it.

Edit: That did not succeed, so here's the workbook on OneDrive: 2026-01-06 RB AutoRenameWorksheet.xlsm