I have a spreadsheet with a few columns. Sheet 1, Column A contains
numbers. Sheet 2, Column A contains the same numbers, just in different
order. I want to be able to say something like - if value in A5 = 32,
copy value the value in D5 and paste it into Sheet 2 where the value in
column A is 32. I want Sheet 2 to have only the values of column A and
Column D.

Thanks in advance!