I am entering parameters in worksheet 1 (i.e. Jones) and corresponding data
in worksheet 2 is based, through vlookup commands on these parameters. I
would like to enter code (preferably at the click of a button on worksheet 1)
to go to worksheet 2, look down Column A for the number 1 (there will only be
one) and copy paste values that data on that row only and then return back to
worksheet 1. This automation would certainly speed up this lengthy process.
Any thoughts?

Worksheet 2
0 Smith 9.98 5.67 4.35
1 Jones 6.57 3.21 8.65
0 Ranz 2.98 7.57 2.22