Hey,

I have one question. Is it possible to merge all sheets in one but horizontally. The macro above merges all the sheets in one sheet vertically, data from the sheets are stacked under each other, I was wondering if I can have the data of each sheet stacked horizontally in one sheet.

The idea is that column A of each sheet represents dates, and I want the data from the other columns of each sheets to be next to each other in the consolidated sheet.

Hope you can help!

Thanx,

Rawan