Let's say I have two worksheets. Each has a specific name, i.e. Person 1 &
Person 2.

In the first Worksheet, I want a heading. The heading should match the
tab's name, i.e. A1 would have a formula that would show "Person 1". So that
if the Tab name were to change, the formula would also reflect the change.

I know that there are codes for headers, i.e. &Tab. Is there a
function/formula out there that I can use?