Copy data from multiple identical sheets to a consolidation sheet by macro

Mel Smith

Well-known Member
Joined
Dec 13, 2005
Messages
832
Office Version
  1. 365
Platform
  1. Windows
I have a workbook consisting of 9 sheets. The layout of each sheet is identical. Sheet 1 (named Combined report) and sheets 2 to 9 will auto-name based on the employees name
which I shall enter into cell A3 as each new sheet is taken into use.

What I would like to do is to have a macro or command button that will copy the contents of each sheet (sheets 2-9) and paste them onto sheet 1 (Combined report) in sheet order, i.e. starting at
cell A4, copy sheet 2, however many lines that may be, and then sheet 3 and so on until all sheets (2 - 9) and copied and pasted.

The data on each sheet to be copied is within the range A4:L4 but the number of rows is variable. It might be one row or 20 rows.

Any help will be very much appreciated!

Mel
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,614
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,808
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top