To change a sheet name as you copy a formula, you will need to employ the INDIRECT function.

Check here for some guidance: http://www.contextures.com/xlFunctions05.html#RefSheet