Combine information from multiple works sheets based on a cell and data in columns

I have attached a sample of my workbook to help explain what I am looking for. The ultimate goal is to be able to produce a worksheet for any given month formated similar to the yellow tabs. The information for each month's sheets comes from the red tabbed sheets of which there are approximately 40. The Red tabbed sheets name can change based on another sheet, so they are not static names. There are additional sheets in the work book that are not the "red" tabbed ones and should not be included in this new worksheet. The tab is only relevant if Cell E11 is greater than 0 (tabs with a 0 in Cell E11 are automatically hidden). The only "tasks " to appear in the new sheet would be the tasks that have an x under the month you are generating the new sheet. Each Red tab should generate its own page like the yellow tabs.

I am trying to learn VBA as I go, but this one seems to be a little over my head for now. This forum has helped me make quite a few improvements to my spreadsheet already. Any help stearing me in the right direction would be greatly appreciated.

I hope I've explained the issue and adheared to the forum rules.

Thanks
Rick