Add data from different sheets to one sheet

Hi Friends, i need your help to combine data from different sheets to one sheet. Below are the points which will clear the picture

•Consolidate values from column G from all the sheets to sheet named “Consolidated” as marked in the last sheet.

•The range of data in the sheets will be fixed in all the sheets

•Sheet names in the workbook will be same apart from the numbering in the brackets, which will keep on increasing or decreasing, like Profile (1), Profile (2), Profile (3), etc or Profile (3), Profile (2), Profile (1)

•Number of sheets is not fixed. There can be a total of 40 or 60 or more sheets

Below is the link of the sample file

Why do you have 5 counts in consolidation while there is only one count in each sheet?

Hi AB33,

i have 5 counts in consolidation, so that the data from each sheet names as profile (1), profile (2), etc should get consolidated in the last sheet in column C, D, E, etc respectively.

I thought we want to add the sum of all rows with the same product. You want a simple consolidation where each sheet figures will go in to each count.

Yes absolutely, you got it correct.

Try the attached.

Wow!!! this is what i was looking for.

but there are few codes which i am not able to understand. it would be kind enough if you can help me in understanding it

why this piece of code is used ("ISREF('Consolidated'!A1)")
What is the purpose of NC = 3

What is the purpose of NC = 3?
is the start of the column and for each loop, it increases by 1.

("ISREF('Consolidated'!A1)")?
is used to evaluate if a sheet name called consolidation exists. If it does not, it creates a new sheet-consolidation.

Thank you very much for your instant responses to my post...