How to put name of spreadsheet in doc

I’ve done this before but I don’t remember how. I need to put the name of the document in the document. I copy this document each month and I would like it to be able to change its name to the new name within the document

This is done via the menu Insert>Header/Footer....

There you have several choices.

If my answer has solved your problem, please click on the checkmark in the circle image description to the left of the answer for upvote. This will tell the community that the question has been answered correctly.

With me Windows 10 Home; Version 1909; 64-Bit | LibreOffice, Version: 6.3.3.2 (x64).

So simple. Much easier then I did it. Thanks!

@BeCheerful

If you need to show in a cell of a sheet, try this.