Copy rows from multiple sheet to master sheet - consolidation

Hi,
I have been reading threads wher i can get solution for what I need. Unfortunately could not get it. Somebody pls help me in getting solution for this.

I have an excel sheet with 7 different sheets out of which 3 sheets are exactly same but differ by only name of the sheet.
1st Sheet - Read me
2nd sheet - Summary
3- 5 - Individual sheets for weekly reporting
6 - consolidation of sheets 3-7
7 - Ranges

Each individual sheets have been split into different activities/sections where in individuals fill in their data in respective sections. Consolidated sheet is exactly the same except an additional column at the beginning which is used to enter individual's name.
I have to work on sheet 6 - Consolidated.Upon completion of filling in individual sheets, i have to copy rows from sections of individuals sheets and paste it in colsolidated sheet in respective locations.In consolidated sheet, more rows need to be entered in respective sections
Sheet which am working is attached below

Re: Copy rows from multiple sheet to master sheet - consolidation

Can anybody help me please? I am badly in need of this.

Re: Copy rows from multiple sheet to master sheet - consolidation

Yeah - Thanks herbds7 . This is what i was looking into. May I get the code for this?

Re: Copy rows from multiple sheet to master sheet - consolidation

HI Herbds7,

Sorry for the confusion created. I hadn't understood your comments on last post. I have MS Excel 2002 only. Coz of this am able to open the doc in read only. Please help me


I have written some code which is incomplete. Instead of consolidating all tasks in 1 sheet, am trying to create master sheet for each task which may reduce complexity. if you can help me in this, would be great.Attached is the sheet.

Issue which am facing now is

Last row is not functioning as expected. Its is counting blank rows in the summary sheet.
Not sure how to get a range dynamically. Ideally, it should give last row ranging from B4 to the row just above 'Total' field.

Your help is much appreciated.