=SUM(COUNTIF(Wk1!$B$8:$F$11,A4),COUNTIF(Wk2!$B$8:$F$11,A4),COUNTIF(Wk3!$B$8:$F$11,A4),COUNTIF(Wk4!$B$8:$F$11,A4),COUNTIF(Wk5!$B$8:$F$11,A4))

As you can see, I want to see how many times the contents of A4 appear in a group of fields on a range of worksheets. Is there a way to shorten this formula as when it is finished i need wk6 wk7 wk8 etc etc through to wk30.

The formula is on the first work sheet, and there will be 30 subsequent worksheets so if it helps, i need that range of cells checking on every other worksheet.

Thanks in advance.