With programming, you can create an Excel UserForm, to use for data entry. Click a button, and the data is stored on a hidden worksheet, and the form is cleared out, so you can start a new entry.
See the Completed UserForm
There are step-by-step instructions and videos on my Contextures website, that show you how to create a basic UserForm.
Someone suggested that it would help them get started, if they could see the finished product first. I agreed, and there is a new video on the web page now.
This video shows the completed form, how it works, and where the data is stored.
I hope this inspires you to get started with UserForms!