macro to auto copy data from multiple sheet to one master sheet

**roger556** · 08-13-2012, 09:54 PM

Hello,
First posting thanks for allowing me to be part of this forum. I have created workbook with 15 workssheets,each worksheet has 8 fix columns viz: name,codes,date,description,starttime,end time,items,difference in time.
I would like to create a macro that would auto copy data from these 8 columns from all the 15 worksheets to one master sheet. Columns are fixed but numbers of rows in each sheet will vary.
Please any advice or suggestions is more than welcomed thanks in advance.

Thanks
Roger

**JBeaucaire** · 08-13-2012, 11:01 PM

'MANY SHEETS TO ONE SHEET

Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1

There's a sample file there, too, to make it easy to try it out.

**roger556** · 10-30-2012, 12:20 AM

Hi JB,
I am sorry for responding so late as I was in an accident so was recovering from it. I wanted to thank you for the solution as it worked out pretty good for me.
Really appreciate your help and once again apologize for the late response.

Roger