Extracting data from various cells in multiple worksheets to another workbook

[Sher31]

Hi all,

I have a workbook that has a worksheet for each month of the year and a worksheet that contains general guidelines.
Could you help me with a VBA code that will extract only E3:AI3, E4:AI4, E5:AI5, E14:AI14, E50:AI50 from all the Worksheets except the 'Guidelines' worksheet to a new work sheet or workbook.
Basically, I want to extract the said 5 rows from all the months 'sheets' and paste a transpose of the same on the output sheet, so they appear as columns.
Hope I'm making sense.

Thanks in advance for any help.

[arlu1201]

Should the various ranges be tranposed next to each other from column A onwards?

Do you need them to be copied to a new workbook or worksheet?

What about the headers for this tranposed data? Should the data start from row1?

[Sher31]

Yes they should be transposed next to each other starting from column A in a new Workbook.
The data should start from row 2.
The Column E is actually the headings for each row.
Thanks in advance for your help.