Need to consolidate the data with an effective formula

.I need formula to calculate H&M phase forecast

.... which is what: what is the logic ???

The "Consolidation" appears to be simply a summation of the corresponding tables in each sheet: an assumption that data is entered (not derived).

Alternative formula

in E5 on "Consolidation"

=SUMPRODUCT(SUMIF(INDIRECT("'" & Sheets &"'!B:B"),$B5,INDIRECT("'" & Sheets &"'!E:E")))

Copy down

Change E:E to F:F, G:G as you copy across

"Sheets" is named range of all your sheet names

Hi John,
Yes you are correct Overall will be the summation only of H&M column and it will be manually entered for all the sheets and same is the case with H&M capacity it will be entered manually for all the sheets.Actually Overall Capacity is divided into two categories H&M and fixed.

consolidation formula will be required for H&M table only .So Please help me with the formula for H&M table.


Regards
Aps