This takes VBA code (macros) to accomplish. There are two ways to do it;
one way would be with a series if InputBox$() statements that get the
information one item at a time and put it on a worksheet;
the second way, and probably much better, would be to create a UserForm to
gather all of the related information at one time and place it on the
worksheet.
I'd be willing to help you get started with this if you'd like. It's a
little more than can easily be covered here in a posting or two, so if you'd
like me to help, just get in touch through email to (remove spaces)
HelpFrom @ JLatham Site.com
and remind me of what you would like me to help with. A link to your
initial posting would be helpful also.