If clicking on e.g. C4, report C1 or A4

[booms]

Hi there

I have data arranged as a table with headings along the first row and first column.

I want to set up a second sheet to pull out the information on the headings for any cells not equal to zero. I thought if, for example, C4 in the first sheet was not zero, I could put in the second sheet ='Sheet1'!C4

I then need the following cells on to automatically report A4 and C1 - these are the two relevant headings that I need to pull out further info.

Any ideas how to do this?

Thanks for your help