Is there a formula to have the Tab name put into a cell.

I have my Tabs with a date of the end of a pay period for payroll. In the
worksheet, I have in a cell "Pay Period Ending" with the cell beside it being
the same date as the tab.

I want it to automatically have the same date as the tab for when I create
new worksheets and name the tabs.

PLEASE let me know if this is possible.

Thanks!