Formula too long - too many sheet names

Hi all,

I have this crazy long formula that won't fit (I will need to make it longer also if possible) in a cell - I get the error "Formula is too long". I have read that I should reference/link the sheet names on another sheet or in 'helper' cells, but I am unsure of how to do this...any help would be appreciated. Workbook attached - TIA

Also - I am very reluctant to change the names of the sheets because they are referenced in several other workbooks....

Formula:

=SUM(IF(ISNUMBER(FIND(" "&C$3&" ","      "&SUBSTITUTE(SUBSTITUTE('Q1 - Jan 1 to Apr 3'!$C7:$P7," ","      "),CHAR(10),"      ")&"      ")),MID("      "&SUBSTITUTE(SUBSTITUTE('Q1 - Jan 1 to Apr 3'!$C7:$P7," ","      "),CHAR(10),"      ")&"      ",FIND(" "&C$3&" ","      "&SUBSTITUTE(SUBSTITUTE('Q1 - Jan 1 to Apr 3'!$C7:$P7," ","      "),CHAR(10),"      ")&"      ")-10,10)+0))+SUM(IF(ISNUMBER(SEARCH("P2",'Q4 - Nov 1 to Dec 31 2011'!$C7:$DJ7)),IF(ISNUMBER(FIND(" "&C$3&" ","      "&SUBSTITUTE(SUBSTITUTE('Q4 - Nov 1 to Dec 31 2011'!$C7:$DJ7," ","      "),CHAR(10),"      ")&"      ")),MID("      "&SUBSTITUTE(SUBSTITUTE('Q4 - Nov 1 to Dec 31 2011'!$C7:$DJ7," ","      "),CHAR(10),"      ")&"      ",FIND(" "&C$3&" ","      "&SUBSTITUTE(SUBSTITUTE('Q4 - Nov 1 to Dec 31 2011'!$C7:$DJ7," ","      "),CHAR(10),"      ")&"      ")-10,10)+0)))+SUM(IF(ISNUMBER(SEARCH("P2",'Q1 - Jan 1 to Apr 3'!$C7:$CH7)),IF(ISNUMBER(FIND(" "&C$3&" ","      "&SUBSTITUTE(SUBSTITUTE('Q1 - Jan 1 to Apr 3'!$C7:$CH7","      "),CHAR(10),"      ")&"      ")),MID("      "&SUBSTITUTE(SUBSTITUTE('Q1 - Jan 1 to Apr 3'!$C7:$CH7","      "),CHAR(10),"      ")&"      ",FIND(" "&C$3&" ","      "&SUBSTITUTE(SUBSTITUTE('Q1 - Jan 1 to Apr 3'!$C7:$CH7," ","      "),CHAR(10),"      ")&"      ")-10,10)+0)))