I using the consolidation function to consolidate several departments each
month, the only issue is that the departments that need to be consliidated
each month changes, is there a way that I can use vba to read from a range of
cells in the worksheets all sheets that need to be consolidatedthat need to
be consolidated each month?

example: finance department month 1 sheet 4 to 10 should be consolidated
month 2 sheet 4, 8, 10 should be
consolidated
--
Helping Is always a good thing