You can use a dialog page to create an input form for your workbook. You can
do it by inserting a worksheet as you have done, or you can insert a dialog
box through visual basic.
If you are familiar with Access forms, you will already know how to create
fields on a dialog box. If not, you might want to look for help on Access
forms or Excel Dialog forms. BTW, if you are using Excel Help, don't type in
"dialog". Try "forms" instead.