When I copy the formula below to several worksheets it copies the old sheet
name into the new sheets. I would like it to reference the sheet name that
the formula is copied into. Is this possible?

=IF('PT TEMPLATE'!A12<>"",BE12,"0.00")
If a new sheet name is 'James' I would like the formula to be:
=IF('James'!A12<>"",BE12,"0.00")