Inserting Text Into Cell Creating New Worksheet with That Text

[Qcheadle]

Hey all,

This is my first post, but it is something I am curious if I can do. I am looking to create a function where if I enter text into a cell and click enter, the text will then appear in a new worksheet in cell, say, A1. In addition, I would also like to know if this newly-created worksheet could be pre-templated by me, instead of just being a new blank sheet. Sorry if this is confusing, but any help would be great!

[Gatti]

Yes... it is possible,

But probably it should be in "Excel VBA", since there is no way to "create a new worksheet" by just enter text into a cell without VBA or Power Automate.