Find corresponding column letter and return entire column data

[Nando1988]

I have 2 sheets in an excel workbook, and I need to get the columns from 1 sheet to the other. I have sheet1 with 3 columns and multiple rows and in column A, I have the letter of the column that has the data for that field. I need a vba script that gets the data for that column letter and places it in sheet2, in the field that needs that data (sheet2 is sheet1 transposed). I have the column headers with the letters and in the second row, the header's text and I need to paste the data from the third row and on, from the column specified with the letter, in sheet1.
Can someone please help me?
Thanks.

 

[onlyadrafter]

Hello,

can you supply screen shots of the two sheets, ideally with the results you expect to see please.