Combine multiple worksheet data into one sheet

[Lizzi]

Hi,

Could someone plse guide me as to how i can combine the data from mutltiple worksheets.

I'm using excel 2007 on a windows 7 pc, my workbook contains 8 worksheets...named East, South etc and i want to combine all the data from those sheets in to another worksheet (within the same workbook) called "total Data"
All the worksheets contain a macro that colour codes cells with missing data and the sheets also contain a conditional format which calculates $$ amounts. The roll up sheet also contains the same macro as the others.

I did not write the macro that the sheets contain, the person that did has left the company, so i'm a newbie to VBA in every aspect of it.

Thanks in advance for any help you can give me and i apologise if this question has been answered before, i did search.....and probably missed the answer.

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

[Lizzi]

Great thanku, i'll take a look