This would require VBA, but the actual code depends greatly on the layout of
your data.  If you wish, send me direct via email a small file that clearly
shows the layout of sheet 2 (column headers).  Also include the headers of
what you want to enter in sheet 1.
   Also tell me where in sheet 2 you want the data placed.  For instance,
do you want the data placed in the next empty row?
Also, do you want to select from drop-down lists in any of the data entry
cells in sheet 1?  If you do, include the lists of items.  My email address
is ottokmnop@comcast.net.  Remove the "nop" in this address.   HTH  Otto