I am trying to populate a cell in one worksheet with data from another
worksheet within the same workbook. The source worksheet (sheet 1) has
a numbered column (Column A) but the numbers do not necessarily match
the cell’s row numbers. The data I want to capture from the source is
in column Q. The destination worksheet will have a column (column A
also) with the number of the row from the source worksheet from which I
want to capture column Q data and place it into column B (on sheet 2).

Code:
--------------------
   
 Sheet 1 (source data)
 Row        A        Q
 1        1        Data point 1
 2        2        Data point 2
 3        3a        Data point 3
 4        3b        Data point 4
 5        4        Data point 5
 
 Sheet 2 (need to populate row B with data from sheet 1 based on the information in Row A)
 Row        A        B
 1        3a   
 2        4   
 3        2   
 4        1   
 5        3b   
 
--------------------