copy and pasting dynamic ranges from dynamic number of worksheets

[cometorta]

Hi All,

I am trying to copy 4 columns A, D, E, Z with dynamic ranges (I the last row number varies by sheet) of all the sheets in a workbook ( the number of sheets in the workbook also varies) into a new sheet in the same workbook.

The copied information needs to be stacked (on top of each other) so that the new file contains only 4 columns.

I really need some help with the looping across sheets as well as dealing with the dynamanic challenge of the macro.

Can someone share or recommend some help.

I am using Excel 2007

Sincerely,

Pancho