Using indirect within a countif on multiple sheets

Good morning,
I have searched Google for last few hours and found no solution for this problem.

I have a workbook which has two sheets: Dashboard and Data Sheet

Data Sheet is a big list of information and Dashboard presents the information nicely into charts, graphs etc. In the data sheet, the user adds new records to the top of the sheet. one of the columns is called type of incident of which there are 5 different values and is input through a dropdown box.

On the dashboard, I want to show the number of each incident so I have this:

Please Login or Register  to view this content.

V is the datasheet column that holds the user input for type of incident and F35 is a text field with one of the names of the incidents.

This works fine and pulls of the results as expected, the problem lies when adding a new row to the top of the datasheet, the formula above will change to

Please Login or Register  to view this content.

note that V12 has changed to V13.

I need V12 to stay as V12 so the formula always uses that as the first value in the range so am using indirect. I have tried the following:

Please Login or Register  to view this content.

BUT GET A #VALUE ERROR.

I can get the forumula to work if I create it in the data sheet and just refer to the results in the dashboard but i really want the calculation to be done in the dashboard

Can anyone offer any help?

Thanks,
That has worked. I've never used the index formula before. I'll have to have a read and see what it can do