Writing a macro that copies data from multiple worksheets to one

[Closed]
Report
Posts
1
Registration date
Monday December 16, 2013
Status
Member
Last seen
December 16, 2013
-
I have a workbook that has over 580 different worksheets, and I need to copy a certain section from each worksheet onto a "master" worksheet. The data is from the range (C7:AI18) and is the same for each worksheet. The worksheets are named "P&L 1", "P&L 2", ... "P&L 578", and my "Master" worksheet is formatted to where each set of data in the range C7:AI18 should be copied below each other with one space in between starting on cell H7. I am trying to write a macro that will pull all of the data from this range from each worksheet and format it on my Master worksheet.