Select from lists

I use Excel in a very basic function day to day.

I now have a task to do where by I need to put together a sheet of various information about an individual product.
I have a total of 700 finished products. Each product has its own individual recipe (which I can type in to cells) plus approx 20 limited variables which each have a choice of 10 or 20 fixed options.

What I want to do is to set up Sheet 1 with type in boxes which will automatically appear into a pre-prepared template in sheet 2 (cells merged etc.). This bit is easy enough.
In addition to this, I want information which can be selected from drop down lists in sheet 1 to also appear in sheet 2.

So, how can I create a drop down list and get the selected cell contents to appear in sheet 2?
For example. Drop down list with Monday Tuesday, Wednesday etc. Selected item to appear in sheet 2

That seems rather easy and workable. It also allows sheet 1 to be very tidy, with all of my lists nicely hidden in sheet 3 for example, nicely protected.

Just now need to see if it works with Excel 2000 on my antiquated work computer.

Thank you for the rapid response.