i would like create a button that when pressed copies specified values from column B, sheet B (i will pick 20 out of maybe ~30 cells) to the latest open row on destination Sheet A starting in column G. i would like to specify by the value in column A of the source sheet B, and return the value from column B. i am using excel 2013.

example: search for 'Units sold USA' in Sheet B is found in A15, return the value of B15 onto Sheet A first blank row after row 20 in column G. repeat for about 20 more pieces of data.

after searching, there seem to be many VBA ways to search for the last used row on a sheet or in a range. i really don't have the experience to know which is the best approach. i'm looking for a straightforward but fairly robust solution that a newbie might learn from & understand. thank you.

example source data on source sheet B, starting at cell B12:
82
82
0
0

82
82
0
28
21
21
0
-4
-3
-3
0
28
-4
1.2764
1.2744
0

6
100.00%
6
0
0
6

14
14
0
0

22
0
26.83%
0.00%

6
0

34:04:00
34:04:00
0:00
1:10:39
0:00

12
12
0

2
2
0
0

14

0
0
0
0
0
82