How's it going.Let me read of your question. Give me a minute.
This is not possible with a formula.
I think you mean a macro?
Can you fill out 2 spreadsheets, one with some basic info like you have said above and one with the finished result (obviously manually entering the info)
This is so I can fully understand what you are asking.
If this is homework of any sort the actual homework would be hand as well If possible
I had to go I did wait on a reply. I am sorry. I will opt out for someone else to help you.
You CAN do it with a formula
It is called vlookup
I am not sure if it will work across different worksheets but you can copy the worksheet you need to an out of the way portion of the worksheet you are on and then use the vlookup