Copy the data from Multiple sheets

[Raghava@rock]

Hi Team,

I need VBA code for Copying the Column A data from multiple sheets which defined in ARRAY and pastet them in the Same work Sheet1 Column A row 3.

Problem i am facing is the lastrow of each sheet is different.

Ho do I Loop the For Each Sheet code to get the data copied from the defined sheets in my ARRAY.

Thanks for your help in advance.

 

[Chihiro]

Not sure what you need exactly. Can you upload sample workbook?