Import data Transpose in VBA loop-Thank you!

I m new to macro and I need to copy the data from row 26:27, 36:37, 46:47 cells value which are converted

into E9:F39, P9:Q39, AA9:AB39, 12 columns in the other workbook. How can I do if I want to import the data

directly instead of making a copy of the report inside of my workbook by using VBA?