In automating this workbook for the client, I've been ask to populate formulas from the attached worksheet to other cells in the same workbook labeled "Consolidated". The range to be populated in the "Consolidated" worksheet would be C6:U17. For example, in cell C6 the formula needs to be ''Jan 14'!B37, cell D6= 'Jan 14'!C37, cell E6 = 'Jan 14'!D37. This is the pattern for each month.
Currently, they have 15 Projects for 2014. Next year, they may want to add another year in the same work book and update the formulas in the Consolidated worksheet. Adding the next year worksheet with the correct tabs labeled has been solved. If I can get a macro that updates the months in the Consolidated for the first year as attached I know I can use that for upcoming year(s).
If I'm unclear, please advise. Thanks to all.