If I can recommend you in advance, always include the information about your Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, etc.) in your question.Ideally, if possible, add a file (without sensitive data) or photo-s with your plans and on the basis of this you explain your plan / wish step by step.
This will save you and others a lot of time.
I don't know which Excel version and operating system you have, but a suggested solution would be with VBA.
Also attached is an example file (write a text in whichever cell you want) and the VBA code.