Copy Tab to Cell

[Liverpool1959]

I have a Spreadsheet with Tamba at the bottom. One for each day of the month. When I select say Jan 5, I also have to enter Jan 5 into Cell E1. Is there a formula I can enter into E1 so it copies the Info on the Tab

 

[bbrnx19]

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1),1))

 

[Phuoc]

Or try

=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

 

[Liverpool1959]

Neither one of these worked

So the first Tab at the bottom is Jan 4. Every day I have to Click on the Tab and then enter The date in Cell E1

Should I mention it is a Google Sheet. Not sure if that matters. The File "Morning Operations January 2022" is shared with 8-10 People

 

[Fluff]

Should I mention it is a Google Sheet.

Not only should you clearly mention that in your post, or title, but you should also post questions regarding sheets in the General Discussion & Other Applications section of the board.
I have moved it for you this time.

 

[Rick Rothstein]

Should I mention it is a Google Sheet. Not sure if that matters. The File "Morning Operations January 2022" is shared with 8-10 People

Infrequently, true, but I keep seeing Google Sheets questions being asked here and wonder why. Doesn't Google Sheets have its own forum devoted to its own product? I know there are similarities, but to expect an Excel solution to work on a Google Sheet seems kind of, well, optimistic to me.