Trying to determine how to go about setting up excel so that:

1) Open the blank worksheet (always remains protected)

2) Form pops up requesting data (ie: name, account #, dates)

3) Excel uses form data to create a new worksheet for user, in a new window
(new worksheet only needs to have certian fields protected), and the
protected worksheet is closed

4) User can utilize new worksheet as needed


I imagine a macro would be the way to go, but I am certianly not the macro
expert. It's also likely there is another way to go about handling this that
I am completely oblivious to.

Suggestions, assistance, macro-wizzes anyone?

Thanks!