Yes, there is a way to make a cell content in a spreadsheet equal to the tab name without having to type the tab name into the cell. Here are the steps:

1. Click on the cell where you want to display the tab name.
2. Type the equal sign (=) to start a formula.
3. Type the function MID followed by an open parenthesis "(".
4. Type the function CELL followed by an open parenthesis "(".
5. Type the text "filename" in quotes, followed by a comma (,).
6. Type the function MID again, followed by an open parenthesis "(".
7. Type the function CELL again, followed by an open parenthesis "(".
8. Type the text "filename" in quotes, followed by a comma (,).
9. Type the function FIND followed by an open parenthesis "(".
10. Type the text "]" in quotes, followed by a comma (,).
11. Type the function CELL again, followed by an open parenthesis "(".
12. Type the text "filename" in quotes, followed by a comma (,).
13. Type the function FIND again, followed by an open parenthesis "(".
14. Type the text "[" in quotes, followed by a comma (,).
15. Type the function CELL again, followed by an open parenthesis "(".
16. Type the text "filename" in quotes, followed by a close parenthesis ")".
17. Type a comma (,).
18. Type the function LEN followed by an open parenthesis "(".
19. Type the function CELL again, followed by an open parenthesis "(".
20. Type the text "filename" in quotes, followed by a close parenthesis ")".
21. Type a close parenthesis ")" to close the MID function.
22. Type a close parenthesis ")" to close the CELL function.
23. Press Enter to complete the formula.

The formula should now display the tab name in the cell. If you rename the tab, the cell content will update automatically to reflect the new tab name.