Hi,

I have 5 different sheets containing data from 5 different locations. All the data in a sheet is kinda consolidated into one column(say Master). All 5 sheets have their own Master column.

I need a macro which can copy all the five Master columns from the five sheets and paste that data in a new sheet.

Could anyone help?


Regards,
Sameer