Insert the worksheet / tab name to where a formula in a cell refers- formula possible?

[DottyDom]

Hi Forum members,

Thanks for all the useful information I've used over the years. I'd like to know if there's a way to insert into a sheet the name of the worksheet that a cell formula refers to, and not the name of the worksheet the cell sits in.

I've looked at many postings on inserting the name of the file, path or worksheet name into a cell and most formula approaches seem based on
=CELL("filename") etc., combined with RIGHT, MID or LEFT
etc., and I'm using one right now.

But is there a way of inserting the worksheet name into a cell that indicates the source worksheet from which a formula in a specified cell gets data or refers to?

I'm interested in this to serve as a simple 'audit' on-screen or in print that calculations on the current sheet are using data from the right place.
I'd prefer the solution to be formula-based and not VBA. It's possible to do this manually but an automatic result is easier, quicker and less subject to human error.

Thanks for any help, tho' I realise not everything's possible.
Dotty