Morning all,

I have a successful Countifs function that accumulates data from an individual sheet;

=COUNTIFS('Week 3.2015'!$A$2:$A$298,$F$2,'Week 3.2015'!$E$2:$E$298,$A21,'Week 3.2015'!$G$2:$G$298,$C21,'Week 3.2015'!$H$2:$H$298,$B21,'Week 3.2015'!$L$2:$L$298,F$3)

I have various sheets for different weeks that I combine on 1 Control sheet that gives a breakdown of the data. At present I copy and paste the function and then manually amend the information for the relevant sheet.

Is there a way of referencing a sheet name in a cell so that it automatically searches for the data required. i.e the same function as above but automatically changes 'Week 3.2015' to 'Week 4.2015'? Having had a look around I think Indirect may work but where do I add it to the above function? Or happy to use another but would like to keep the Countifs the same.

Thanks in advance,

Phil