Data extract from multiple sheets to one

**ASH2707** · 03-15-2011, 04:58 AM

As always, I apologise if I’m duplicating a thread. I have searched the forum and see similar ‘ish threads, but not quite what I’m after and remain unsolved….

My workbook has sheets for each month of the year. The columns are the same on each, just varying amount of rows to a maximum of 50.

Is there a way I can use a macro? Which will copy data from each sheet and place it into a ‘master sheet’?

Thanks in advance as always

**royUK** · 03-15-2011, 05:02 AM

Why not have all the data on one sheet in the first place?

**ASH2707** · 03-15-2011, 05:08 AM

Because the monthly sheets build as I go and I dont get the next months data until a few days before hand, I also have to produce a monthly reports

**abousetta** · 03-15-2011, 06:11 AM

If you could post a dummy workbook to demonstrate how the worksheets are structured then it would be helpful.

Also state whether or not its one workbook or if there are several workbooks that you will want to merge.

abousetta