Hi Everyone,

I need to consolidate 31 sheets on to one sheet in the same workbook.
Each sheet has 7 columns (they are all the same). The range of data
that I need to consolidate from each sheet is always b5:h125. The
issue that I'm having is that 3 of the columns are validated lists
(with help from Debra Dalgleish) and 2 are equal to an initial entry
with a formula equalling the cell above for the rest of the column.

I tried, with limited success, to use DataConsolidate option but that
would only consolidate the data that was actually entered manually
into the sheets rather than the values that were chosen from the drop
down lists.

Is there any way I can consolidate these values in one sheet?

Thanks,

Dani