Excel countifs function result depends upon sheet name selection

Dear Expert

This is my first post

I HAVE WORKBOOK CALLED COUNTIFS.XLS IN THAT I HAVE MAIN SHEET "REPORT" RETRIEVE DATA FROM SHEET THROUGH COUNTIFS FUNCTIONS

MY REQUIREMENT IS GET CHANGE RANGE OF DATA DEPENDS UPON SHEET NAME (A17) CELL.
I HAVE MULTIPLE SHEET(22-07,23-07,24-07,25-07,26-07,27-07) CONTAINS SAME RANGE OF DATA.

E.G= IF I SELECT THE 23-07 SHEET NAME IN A17. I WANT RESULT FROM 23-07 RANGE OF CRITERIA ,SO RESULT WILL GET CHANGE IN FORMULAS