Copy data from 1 sheet to another sheet base on serial number input

Hi,
I am working to copy the data from 1 excel sheet and paste to another sheet base on user input on the serial number enter.

attached a simple example.

hope someone can help me in this.

Thanks

Here is one that I use a lot, that allows you to click a button to transfer data from the current selected row. If you press the button from a row that does not have a value in the Serial Number Column it will provide a message box to try again.

nice idea... and it seem to work fine..
Thanks